Collation error in SQL views

Gather feedback on your content with community scoring - these ratings weight results in adaptive search. Through curation analytics, ratings are used to highlight pages in need of attention. Learn more on enabling these capabilities with MindTouch 2010.

Inhaltsverzeichnis

keine Gliederung

Accessing tblSyncLog with union between ntadm2 and ntadm2_archive can fail with sql collation errors. Reason is that not all columns of table has the same collation.

To avoid the problem change column of single columns to standard for all columns of table, e.g.:

ALTER TABLE dbo.tblSyncLog

ALTER COLUMN Process nvarchar(200) COLLATE SQL_Latin1_General_CP1_CI_AS

Was this page helpful?

Yes No

Tags (Schlagworte bearbeiten)

Was verweist hierher