Changing the collation order | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Changing the collation order

I had to change the collation order in Sql 2005 at server level and not the database level. Do I have any option of doing that other than reinstalling the server.
Without installing sql you can do by rebuilding the master database. Check the following…
SQL Server 2005 Books Online
Setting and Changing the Server Collation
http://msdn2.microsoft.com/en-us/library/ms179254.aspx How to transfer a database from one collation to another collation in SQL Server
http://support.microsoft.com/kb/325335 MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20750 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>