SQL Server Performance Forum – Threads Archive
Changing the collation orderI 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
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
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.