Changing Collation | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Changing Collation

hi guys, What ar the steps involved in changing the collation of MS-Sql server 2000. As i need to transfer data from one server to other, the problem is they have a different collation. I don’t want to change the collation at database, table and columns level.. THanks in advance
Whenever you fall, pick something up. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

If you need the complete change of collation then you have to reinstall SQL server with relevant collation, otherwise you could take help of setting up the database wide collation where the new data can only be affected. 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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
you can script all the tables and database (with the destination server’s collation), then use DTS to tranfer the data. You need to make sure you tranfer all objects, indexes, stored procedures etc. This will save having to change collation at any point.