SQL Server Error Msg 1996 – Could not create index enforcing primary key constraint ‘%.*ls’ using DROP_EXISTING option because table has an XML or spatial index. Drop the XML or spatial index, create the primary key contstraint, and recreate the XML or spatial index.

In this blog post, let’s learn about the error message “1996 – Could not create index enforcing primary key constraint ‘%.*ls’ using DROP_EXISTING option because table has an XML or spatial index. Drop the XML or spatial index, create the primary key contstraint, and recreate the XML or spatial index.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

1996 – Could not create index enforcing primary key constraint ‘%.*ls’ using DROP_EXISTING option because table has an XML or spatial index. Drop the XML or spatial index, create the primary key contstraint, and recreate the XML or spatial index.

Reason for the Error

To be update soon…

Solution

To be update soon…