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…
