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

ERROR: Collation conflict!!! Expand / Collapse
Author
Message
Posted Friday, February 18, 2011 4:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 10:29 AM
Points: 186, Visits: 811
Hello,

Does any know how can i resolve the following issue with the minimum impact in the production environment.
There are a lot of databases that were migrated from a SQL Server Instance with a collation to anotherwith another collation.
I apreciate if you can help me to find the fastest and secure solution.

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS"

Thanks and regards,
JMSM :)
Post #1066254
Posted Friday, February 18, 2011 6:02 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 13, 2012 3:40 AM
Points: 16, Visits: 20
This is usually conflict tempdb x yourdb, so rewrite stored procedures and add collate database_default. You can, however, try alter table alter column and unify collation
Post #1066293
Posted Friday, February 18, 2011 7:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 10:29 AM
Points: 186, Visits: 811
Hello,

I dont understand when you're telling me "conflit between tempdb and youre database".
The server collation its different in both instances and there's an aplication that automatically will create databases. So i cant change anything in the sp's.

Hope you can help me so that i can change collation in one of the instances or that you tell me the best way with less impact so that i can correct the problem.
Thanks and regards,
JMSM
Post #1066372
Posted Friday, February 18, 2011 7:12 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 13, 2012 3:40 AM
Points: 16, Visits: 20
tempdb is dynamically created and always copy collation of the mater db. Temporary tables are stored in tempdb. So if your db has different collation than master db has any operation with temporary table will cause collation conflict.
Post #1066374
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse