December 3, 2009 at 9:08 am
Correct me if I'm wrong, is the only way to change the Server Collation on the database is to do a reinstall of SQL no the Server And is it possible to have one database (A) set to Case Insensitive and a different database (B) on the same server set to case sensitive?:hehe:
December 3, 2009 at 9:22 am
Kevin-130791 (12/3/2009)
Correct me if I'm wrong, is the only way to change the Server Collation on the database is to do a reinstall of SQL no the Server And is it possible to have one database (A) set to Case Insensitive and a different database (B) on the same server set to case sensitive?:hehe:
Database collation case sensitive and case insensitive can be defined when created or later changed if SQL Server 2005 SP2 and up. If you want case sensitive you could use BIN (binary sort) which is the fastest sort and case sensitive by default or just use case sensitive collation.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply