SQL Server error code
SQL Server error 1996
SQL Server raises error 1996 at severity 16, which marks a problem with the query or data that you can correct.
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 constraint, and recreate the XML or spatial index.
| Msg | 1996 |
|---|---|
| Severity | 16 |
| Group | 1000–1999 |