Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home

Symptoms

When database has a non standard collation and a Disabled Index View is generated during sync, this will throw an error as the create view statement cannot properly determine the collation to use.

This will cause the upgrade to fail with an error like:

'[Microsoft][ODB

C Driver 13 for SQL Server][SQL Server]Cannot resolve the collation conflict between  "Latin1_General_CI_AS_KS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

↑ Back to the top

Resolution

This hotfix corrects the view creation logic to add a COLLATE DATABASE_DEFAULT clause which resolves the error on view creation.

↑ Back to the top

More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top

Article Info
Article ID : 4095641
Revision : 1
Created on : 3/15/2018
Published on : 3/15/2018
Exists online : False
Views : 176