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
 SQL Server Administration (2005)
 Adjusting Collation

Author  Topic 

ausmoran
Starting Member

5 Posts

Posted - 2007-04-18 : 11:55:04
Can you point me in the correct direction in SQL2005 Server to adjust the SQL Server database collation case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive. We are trying to configure it to run with SharePoint Services.

Thanks in advance for any assistance that you might be able to provide.

-Austin

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-18 : 15:39:57
You can do it with 'alter database', but may need rebuild master db since wrong collation of objects in tempdb will break apps.
Go to Top of Page
   

- Advertisement -