Our product database has several procedures that acutally JOIN to tables
MSDB and sometimes MASTER. For the JOIN to succeed, the joined columns must
share the same collation, apparently.

Typically, customers create our product DB using our tool, and so the SQL
Server default collation is used, and MSDB/MASTER match our DB, and things
are fine. Well, one customer creates a template DB once, then restores to
various servers. Now, they have different collation between our DB and
MSDB/MASTER, and some of our stuff fails because of this.

What is the easiest way to change the collation for the entire DB? I'm
thinking that the best solution is to change our DB to match the default
collation of their server, which will render it JOIN compatible with
MASTER/MSDB. (Right now, all I can think of is DTS or some other
export/import scheme. The simple ALTER TABLE fails, and complains that our
constraints depend on database collation.)

If there is an FAQ that I missed, I'd sure love a referral. Any words will
be greatly appreciated!

Thanks in advance,

James Hunter Ross

Report this post to a moderator