Re: Need help with case sensitivity

Article View: comp.databases.ms-sqlserver

Article #59

Back to comp.databases.ms-sqlserver Previous Next

#59

From: 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

Technical Details

Message-ID: <33232D12.41C6@tdr.dk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <5fl1qs$bes@gap.cco.caltech.edu> <VA.000001d8.0077cdff@neilpikeport>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,73d4a89326f58b69
X-Google-Attributes: gid11355a,public
X-Google-Thread: 104de1,73d4a89326f58b69
X-Google-Attributes: gid104de1,public
From: Karsten Nyblad <karsten@tdr.dk>
Subject: Re: Need help with case sensitivity
Date: 1997/03/09
Message-ID: <33232D12.41C6@tdr.dk>
X-Deja-AN: 224238969
References: <5fl1qs$bes@gap.cco.caltech.edu> <VA.000001d8.0077cdff@neilpikeport>
Organization: Tele Danmark Research
Newsgroups: comp.databases.ms-sqlserver,bit.listserv.sqlinfo

Reply to Parent Message