Make SQL 2000 case sensative

[ChrisQuick]

Hi:

I've just spent the better part of two days creating a SQL Server 2000 database only to discover that it does not appear to be case sensative when checking equality in character columns.

Is there any way to retroactively make the database case sensative? cquick@geotg.com
Geographic Information System (GIS), ASP, some Oracle

 

[tlbroadbent]

Alter the database and set the collation to a case sensitive SQL collation. You can alter collation for the entire database or for individual columns. Check the topics "Alter Database", "Alter Table", "Collate" and "Collations" in SQL BOL. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[ChrisQuick]

Thank you for answering my post (sort of at least).

Considering that your advice is to look at certain topics in the BOL and then point me to a faq that lists the Site-Etiquette (including looking in the BOL), that there is a distinct effort to suggest (or assume) that I did not.

Let me correct that.

I did look in the BOL. Unfortuenetly the BOL is a little unclear and rather convoluted when addressing what I wanted to know. While it is true that almost any question can be answered through the documentation, pointing people to the documentation is not an answer in and of itself. I would hope that your status as one of this forums top experts is not based on that.

From what I've gathered I am going to have to:

Export all of my data, drop all of my databases, rebuild the master database specifying the new collation and then import back in my datbases, objects and data.

The other alternative is to migrate the database to Oracle (my preference) and not have to worry about MS's BS like this again.

If there is anyone else who could provide some information beyond that or point me too some information or articles outside the BOL, I would appreciate it.

Geographic Information System (GIS), ASP, some Oracle

 

[tlbroadbent]

I apologize if you feel offended. I did not mean to imply that you had not read the documentation.

My first sentence answered your query. Phrased differently it says, "You can make the database case sensitive by altering the database collation." I didn't give you the details but mentioned where to find the details about doing that. You can take me to task for my answer or you can ask more questions for clarification. And if you don't want me to answer, I won't.

The line "Please review FAQ183-874" is part of my signature. It is not directed at any person. It appears on all of my posts. There was no implication on my part that you had done anything wrong. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin