Posted by Alex on 10/05/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

• Next in forum: newbie question on SQL frontends
• Prev in forum: splitting a comma seperated column into multiple rows
• Thread view: Re: changing collations

[Reply to this message]