Case Sensitive of MSSQL2005

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=246692&SiteID=1
Form reply of "Absolute_Zero":
In order to get the case senstive to work, go inside SQL 2005 and right click the column and choose modify. Under neith the table designer field click the Collation button which will bring you to more advanced options. Next, choose Windows Collation | Dictionary Sort | Case Sensitive. Then queries ran against the column will now check for case sensitivity.

I got a problem.
1) MSSQL2005, by default, data is non case-sensitive?
2) How to use SQL cmd to change "Windows Collation | Dictionary Sort | Case Sensitive"?
3) How to make MSSQL2005, default is case-sensitive?

The default collation is set upon instalaltion time, for changing either tables / database or the whole server, refer to:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36707

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Working with collations is documented in the SQL Server Books Online.

Working with collations

Setting and changing collations

Cheers,

Dan

sql