|Subject:||Collation problem - urgent help|
|Posted by:||Nasir (nmaje…@prosrm.com)|
|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.