sql from case insensitive to case sensitive

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

sql from case insensitive to case sensitive

Author

Topic

imycheng
Starting Member

1 Post

Posted - 2004-09-16 : 05:47:08

Hi,

i have set up a sql 2000 server long time ago. at the time i do the installation, i don't care much about the case sensitivity setting of the server, so the server is now configured as case-insensitive. however, the issue now become important. i need to reconfigure the sql server from case insensitive to case sensitive. could anyone tell
me how to CHANGE a sql server 2000 from case insensitive TO case sensitive without reinstallation? as i would highly prefer re-configuration instead of re-installation. do anyone know about this? please advise. please help...........thanks thanks in advance.

irene

Amethystium
Aged Yak Warrior

701 Posts

Posted - 2004-09-16 : 06:22:47

Hi there,

I assume that you know the current server collation, if not then use sp_server_info. The attribute_ID = 18 should contain the collation name of your server.

As an exmaple, my own server collation is Latin1_General_CI_AS

Note that it is currently Case Insensetive : Latin1_General_CI_AS

To change it to Case Sensetive you just change the collation name like this : Latin1_General_CS_AS

You can then use the ALTER DATABASE comand to change the collation of the server. (refer to Books On Line for further help!)

Not sure on this so you might have to check, but I think that any objects created prior the above change will not have the new collation and they wil remain on the previous collation.

Hope this helps.

------------->>> BREAKING NEWS!!! <<<-------------

Saddam Hussien has weapons of mass destrcution

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources