Hi!

There is a script to change the collation of an entire database at this link:

http://www.sqlservercentral.com/scripts/Miscellaneous/30471/[/url]

The correct syntax may be like this:

ALTER TABLE tablename

ALTER COLUMN columnname type (length) COLLATE database_default

I've tried...