February 18, 2011 at 4:18 am
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 🙂
February 18, 2011 at 6:02 am
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
February 18, 2011 at 7:10 am
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 🙂
February 18, 2011 at 7:12 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply