Again, thanks for the help, I just have one more question.......
I have been playing around with the ALTER TABLE command in the article and I can change the collation to any collation name - The other databases have a blank collation, since they were created using "Server Default" I assume. I am unable to change the collation to "Server Default", and I am not sure what my server default is. I looked through SQL Server settings, but maybe I am missing something. Can I be directed to how I can determine what the collation name is for the server default? Hope this makes sense.
Originally posted by m3122
Thanks...I checked this and the collation is blank. What does this mean?
In Query Analyser select the database node, right click and select Script to new window for CREATE. This should generate the full SQL create script for the database including it's specific collation.
If you have data in the database that needs recollating you have to remove all indexes, statistics and constraints that reference the collatable fields, ALTER the individual tables, ALTER the database and reapply all the removed entities. I put a two-stage script that will do this about a month ago.