SQL case sensitive -- change to not case sens???

[Gulag]

Hi gang..

I have a Windows 2000 server, SQL 2000..
but the problem is that the SQL server was installed in case sensitive mode.

Is there any way to change that without re-installing the SQL server?

thx in advance.

 

[SQLBill]

You can use the ALTER DATABASE command.

ALTER DATABASE <databasename> COLLATE <collation name>

You can find collation names by running this:

SELECT *
FROM ::fn_helpcollations()

Note: You change COLLATE not only for the collation language, but also for the case-sensitivity.

Refer to the Books OnLine for more information on ALTER DATABASE and COLLATE.

-SQLBill

 

[Gulag]

xcellent... thank you very much...

this worked

 

[Gulag]

Found a much better way,,
in regedit, find a key called defaultCollation
and change it to what you want... that changes the whole SQL server, not just individual databases...

 

[Glyndwr]

This does not change the collation for existing tables, only for new ones

 

[scc]

If I'm reading this right, the SQL Server 2000 itself can be set up as case sensitive or a specific database can be set up case sensitive?

If you have any links or key words to help me find this on Microsoft's website (or any other good site) or in books on line, that would be helpful.

Thanks.

 

[mrdenny]

You can select the collation for the Server, a database, a table, or a specific column in a database. None of those have to be the same as the other ones.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SQLBill]

In BOL, use the Index tab and enter Collations.

-SQLBill