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

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

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 issue is fixed in the following cumulative updates for SQL Server:

Cumulative Update 5 for SQL Server 2016 RTM

Cumulative Update 2 for SQL Server 2016 SP1

Cumulative Update 4 for SQL Server 2014 Service Pack 2

 

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.