case sensitive database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

case sensitive database

how can we create a case sensitive database in sqlserver 2005?
while creating the database ,if we set the collation as SQL_Latin1_General_CPI_CS_AS , is the database will get created as case sensitive
Yes In CREATE DATABASE statement you have to use COLLATE clause…
MohammedU.
Moderator
SQL-Server-Performance.com
]]>