Changing SQL Server collation without DTS
If you find yourself needing to change collation on databases when you restore them; you can DTS the data but that is fraught with risk. the fantastic script here
http://www.db-staff.com/index.php/microsoft-sql-server/69-change-collation
can do it in one pass without changing the objects in the database :)
-
mangalcun liked this
-
sqlscripts posted this
