Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Collation Issue.

We have our replicated Salesforce SQL Server database Collation set to "SQL_Latin1_General_CP1_CI_AS". When we run the sf_refresh stored procedure we get the following error. If we change the Collation of our replicated Salesforce SQL Server database to "Latin1_General_CI_AS" the sf_refresh stored procedure works fine but we have problems with Collation with our other internal databases which have the "SQL_Latin1_General_CP1_CI_AS" Collation. We have configured our Linked Server based on the settings on page 7 of your documentation. Can you please let us know if there is any solution for this issue?
Msg 468, Level 16, State 9, Line 1
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
--- Ending SF_Refresh. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Refresh, Line 623
--- Ending SF_Refresh. Operation FAILED.
1 person has
this problem
+1
Reply