Need help with case sensitivity

Thread View: comp.databases.ms-sqlserver

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Brent Eubanks Thu, 06 Mar 1997 00:00

#55

Author: Brent Eubanks
Date: Thu, 06 Mar 1997 00:00

17 lines
927 bytes

I am running MS-SQL Server 6.5 under NT 4.0
I was wondering if there is some way to turn on case sensitivity
without reinstalling
the server software.  The only reference to the issue of case
sensitivity implies that
it is not possible, but I find this hard to believe, and would like
confirmation.

Thanks

Brent

--

--
Brent Eubanks					    brent@ugcs.caltech.edu

Re: Need help with case sensitivity

#59

Author: Karsten Nyblad
Date: Sun, 09 Mar 1997 00:00

27 lines
1570 bytes

Neil Pike wrote:
> 
> > I was wondering if there is some way to turn on case sensitivity
> > without reinstalling
> > the server software.  The only reference to the issue of case
> > sensitivity implies that
> > it is not possible, but I find this hard to believe, and would like
> > confirmation.
> 
> Brent,
> 
> No, you have to re-install SQL Server to change the sort-order.

Wrong.  Rebuilding the master database with a new sort order is
sufficient.  Please note that you lose all your databases, logins etc.
when you rebuild the master database.  You can't even restore backup of
old databases if you change the sort order.  You can change the
file name of the master database before rebuilding it.  Then you
can change back to the old master database just by restoring the
old name file name of the master database.  The master database is
rebuild by the setup utility which is also used for changing the
file name of the master database.

Karsten Nyblad
karsten@tdr.dk
Tele Danmark R&D

Re: Need help with case sensitivity

#60

Author: Ken Klaft
Date: Mon, 10 Mar 1997 00:00

37 lines
2031 bytes

If you have the ability, you can move the data from one server to another.
Basically, I'd move the original databases to another server temporarily, 
then upgrade your existing server, then use transfer manager to copy the 
data from the temporary server to the new server (with the correct sort order.)

Cheers,
Ken

In article <33232D12.41C6@tdr.dk>, karsten@tdr.dk says...
>
>Neil Pike wrote:
>> 
>> > I was wondering if there is some way to turn on case sensitivity
>> > without reinstalling
>> > the server software.  The only reference to the issue of case
>> > sensitivity implies that
>> > it is not possible, but I find this hard to believe, and would like
>> > confirmation.
>> 
>> Brent,
>> 
>> No, you have to re-install SQL Server to change the sort-order.
>
>Wrong.  Rebuilding the master database with a new sort order is
>sufficient.  Please note that you lose all your databases, logins etc.
>when you rebuild the master database.  You can't even restore backup of
>old databases if you change the sort order.  You can change the
>file name of the master database before rebuilding it.  Then you
>can change back to the old master database just by restoring the
>old name file name of the master database.  The master database is
>rebuild by the setup utility which is also used for changing the
>file name of the master database.
>
>Karsten Nyblad
>karsten@tdr.dk
>Tele Danmark R&D

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads