Dear All

Maybe 2008 has a mechanism for doing this but 2005 certainly does not.

These scripts All assume that the Collation of the SERVER is set to what you need it to be. All they do is change the collation of every text column on every table in the database that you run it against to the collation of the server.

In order to do that you have to remove any Indexes, FK Constraints, PK Constraints and Check Constraints. The 1st 5 Scripts Just Generate the commands that you will need to put them back afterwards. That is why there are cursors on system tables.

These scripts have been proved time and time again when taking Databases that have been installed by 3rd party vendors that do not match my collation. The worst of which was a Dynamics GP 10 Database.

Paulus