Tag: MS SQL Server Error Codes

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…