FIX: Can't set a database to partial containment if SQL Server change tracking was ever enabled on that database

Symptoms

Consider the following scenario:

  • You perform at least one insert, update, or delete against a table that has change tracking enabled.
  • You disable all change tracking within the database.

In this scenario, even after you have disabled change tracking, when you try to set the database to the partially contained database model, you may receive an error message that resembles the following:


Resolution

The fix for this issue is included in the following cumulative update for SQL Server:

4010394 Cumulative Update 4 for SQL Server 2014 Service Pack 2

About cumulative updates for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were included in the previous cumulative update. Check out the latest cumulative updates for SQL Server:

2936603 Latest cumulative update for SQL Server 2014

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 Microsoft uses to describe software updates.
Svojstva

ID članka: 3212318 - Poslednji pregled: 21.02.2017. - Verzija: 24

Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Standard

Povratne informacije