SQL Server Error Code – 1996 could not create index enforcing primary

In this blog post, you’ll learn more about the SQL Server Error Code 1996 and the error message description that is shown

SQL Server Error Code

1996

SQL Server Error Description for the Code :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.

Leave Your Comment