Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Beware of Mixing Collations - Part 1 Expand / Collapse
Author
Message
Posted Friday, January 10, 2003 8:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, April 12, 2014 6:50 AM
Points: 1,040, Visits: 274
TEMPDB table do present problem in a mixed collation environment. The TEMPDB takes on the collation of the MSDB database every time the server is restarted. One option might be to set your MSDB collation to the most common collation used, therefore minimizing the issues with collations differences across databases.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples


Gregory A. Larsen, MVP

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #49618
Posted Friday, January 10, 2003 8:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, April 12, 2014 6:50 AM
Points: 1,040, Visits: 274
TEMPDB table do present problem in a mixed collation environment. The TEMPDB takes on the collation of the MSDB database every time the server is restarted. One option might be to set your MSDB collation to the most common collation used, therefore minimizing the issues with collations differences across databases.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples


Gregory A. Larsen, MVP

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #49619
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse