Posted by Alex on 11/01/82 11:37

I wrote a tool that generates a script to change the collation of each
column in the database

http://www.codeproject.com/useritems/ChangeCollation.asp

I ran this agains a 20 GB data warehouse and it worked fine for me.

You may want to enhance the code a little to script all 150 databases
automatically

Alex

[Back to original message]