SQL Server Error Msg 3735 – The primary key constraint ‘%.*ls’ on table ‘%.*ls’ cannot be dropped because change tracking is enabled on the table. Change tracking requires a primary key constraint on the table. Disable change tracking before dropping the constraint.

In this blog post, let’s learn about the error message “3735 – The primary key constraint ‘%.*ls’ on table ‘%.*ls’ cannot be dropped because change tracking is enabled on the table. Change tracking requires a primary key constraint on the table. Disable change tracking before dropping the constraint.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

3735 – The primary key constraint ‘%.*ls’ on table ‘%.*ls’ cannot be dropped because change tracking is enabled on the table. Change tracking requires a primary key constraint on the table. Disable change tracking before dropping the constraint.

Reason for the Error

To be update soon…

Solution

To be update soon…