Tuesday, January 28, 2014
collation conflict between two databases
Below error coming when collation conflict between two databases:
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Resolution:
INNER JOIN [test1\test1].CRM_PROD_MSCRM.dbo.Brit_TobaExtensionBase BTE ON BTE.Brit_BRMCode COLLATE DATABASE_DEFAULT =O.CRMID COLLATE DATABASE_DEFAULT
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment