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 How to transfer a database from one collation to another collation in SQL Server MohammedU.
Moderator All postings are provided “AS IS” with no warranties for accuracy. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.