Collation problem - urgent help

Giganews Newsgroups
Subject: Collation problem - urgent help
Posted by:  Nasir (nmaje…
Date: Mon, 21 Aug 2006

What is the best way to resolve these collation errors:

My server is installed as - Latin1_General_CS_AS, but one of  the important
50GB databases migrated from another server has -
SQL_Latin1_General_CP1_CS_AS, and we are getting errors:

Msg 468, Level 16, State 9, Line 1
Cannot resolve the collation conflict between "Latin1_General_CS_AS" and
"SQL_Latin1_General_CP1_CS_AS" in the equal to operation

WHat sthe best way to resolve these problems...would bcp in/out fix it?

Tnanks in advance.