FIX: The INSTEAD OF trigger uses a different collation than the contained database uses in SQL Server 2012 or SQL Server 2014

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard

Symptoms


Assume that you create an INSTEAD OF trigger that uses inserted or deleted tables in a contained database in Microsoft SQL Server 2012 or SQL Server 2014. Unexpectedly, you may find that the INSTEAD OF trigger uses a different collation than the collation that's used by the contained database.

For example, the contained database uses a case-insensitive collation and the INSTEAD OF trigger uses a case-sensitivity collation.

Cause


This issue occurs because the INSTEAD OF trigger does not use the DATABASE_DEFAULT collation for inserted and deleted tables in the contained database.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.