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


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:



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


Learn about the terminology Microsoft uses to describe software updates.