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

Testing a new linked server. Running a "select * from SALESFORCE...Account" works ok. Using the stored procedures fails.

--- Starting SF_Replicate for Account V3.4.4
15:25:41: Drop Account_Previous if it exists.
15:25:41: Create Account_Previous with new structure.
15:25:49: Error: Salesforce table does not exist: Account
15:25:49: Error: Cannot convert to text/ntext or collate to 'Latin1_General_100_CS_AS_SC' because these legacy LOB types do not support the Unicode supplementary characters whose codepoints are U+10000 or greater. Use types varchar(max), nvarchar(max), or a collation which does not have the _SC flag.
--- Ending SF_Replicate3. Operation FAILED.

SQL Server collation: Latin1_General_100_CS_AS_SC
Salesforce Backup database: Latin1_General_100_CS_AS_SC

SQL Server version: 11.0.6020.0
Windows Server: Windows Server 2012 R2
1 person has
this problem
+1
Reply