Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Changing Case Sensativity of Master

Author  Topic 

opowell
Starting Member

12 Posts

Posted - 2010-11-03 : 13:30:45
Question is this. I have a vendor who as asked me to change the collation of the master database to _CS_ from _CI_. What is the cause and effect of this change. and if it is change to _CS_, can I still apply patches and CU to this eviroment.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2010-11-03 : 14:15:30
SQL Server 2005 Books Online says you can't.


SQL Server 2005 Books Online (September 2007) topic:
"master Database
...
Restrictions
The following operations cannot be performed on the master database:
Changing collation. The default collation is the server collation.
..."


CODO ERGO SUM
Go to Top of Page
   

- Advertisement -