August 4, 2005 at 2:57 pm
My database server default Collation is "SQL_Latin1_General_CP1_CI_AS" .
We Created a Test DB with database collation "Latin1_General_BIN" and another test database with "SQL_Latin1_General_CP850_BIN" .Will there be any potential issues if these two are used in the same instance?
August 4, 2005 at 3:13 pm
Stored procedures or other SQL which uses temporary tables may need to specify the collation on the 'create' for the temporary table if specific collation behavior is desired, since tempdb will have the default collation and you may want the temporary table to behave as though it was in a database with a different collation. That's the only real problem I've run into with mixed databases on the same server. My experience has been limited, so there may certainly be other serious considerations, especailly if the non-default database might be involved in replication.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply