SQL Server Collations Settings
Posted on 2007-04-11
I have 2 SQL Server 2000's. One is a DEV_Server and one is a LIVE_Server.
I have 2 Databases one is a DEV_DB and one is a LIVE_DB.
My problem is to do with the "Collation" settings.
LIVE_Server is set to Latin_General_CI_AS
DEV_Server is set to SQL_Latin1_General_CP850_CI_AS
LIVE_DB is set to SQL_Latin1_General_CP850_CI_AS
DEV_DB is set to SQL_Latin1_General_CP850_CI_AS
When I run SQL scripts againist DEV_DB on the DEV_Server all is perfect.
When I run SQL scripts againist LIVE_DB on the LIVE_Server I get all sorts of unexpected locks etc etc (it is just not happy!!)
I have put this down to the Collations being different.
My questions are "What is the quickest way to get the LIVE_DB to run on the LIVE_Server"? And what (if any) are the implications to the servers, my databases or any other databases on the servers?
Please bear in mind also I CANNOT change to collations of either of the servers (company rules!)
Hope someone can help please!