SQL Server Errors or Failures Error: 1977 to Error: 1996



Error: 1977, Severity: 16, Could not create %S_MSG ‘%.*ls’ on table ‘%.*ls’. Only XML Index can be created on XML column ‘%.*ls’.
Error: 1978, Severity: 16, Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as a key column in an index or statistics.
Error: 1979, Severity: 16, Cannot use index option ignore_dup_key to alter index ‘%.*ls’ as it enforces a primary or unique constraint.
Error: 1980, Severity: 16, Index cannot be created on computed column ‘%.*ls’ of table ‘%.*ls’ because the underlying object ‘%.*ls’ has a different owner.
Error: 1981, Severity: 10, Warning: The maximum length of the row exceeds the permissible limit of %d bytes. For some combination of large values, the insert/update operation will fail.

Error: 1982, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’ because the view references non-deterministic or imprecise member function ‘%.*ls’ on CLR type ‘%.*ls’. Consider removing reference to the function or altering the function to behave in a deterministic way. Do not dec
Error: 1983, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’. The function ‘%s’ yields imprecise results. Use a precise system function, or modify the user-defined function to return precise results.
Error: 1984, Severity: 16, Index ‘%.*ls’ cannot be created or rebuilt. The specified row length for this index using the vardecimal storage format exceeds the maximum allowed length of ‘%d’ bytes.
Error: 1985, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’. It contains one or more XML data type methods.

Error: 1986, Severity: 10, Cannot replace non-hypothetical index ‘%.*ls’ with a hypothetical index using the DROP_EXISTING option.
Error: 1987, Severity: 16, Cannot %S_MSG %S_MSG ‘%.*ls’ on %S_MSG ‘%.*ls’ because its %S_MSG is disabled.
Error: 1988, Severity: 16, Cannot rebuild clustered index ‘%.*ls’ online because it is disabled.
Error: 1989, Severity: 16, Cannot enable foreign key constraint ‘%.*ls’ as index ‘%.*ls’ on referenced key is disabled.
Error: 1990, Severity: 16, Cannot define an index on a view with ignore_dup_key index option. Remove ignore_dup_key option and verify that view definition does not allow duplicates, or do not index view.
Error: 1991, Severity: 16, Cannot disable clustered index ‘%.*ls’ on table ‘%.*ls’. Permission denied to disable foreign key ‘%.*ls’ on table ‘%.*ls’ that references this table.
Error: 1992, Severity: 10, Warning: Foreign key ‘%.*ls’ on table ‘%.*ls’ referencing table ‘%.*ls’ was disabled as a result of disabling the index ‘%.*ls’.
Error: 1993, Severity: 16, Cannot partition an index on a table variable or return table definition in table valued function.
Error: 1994, Severity: 16, Cannot create or update statistics on view “%.*ls” because both FULLSCAN and NORECOMPUTE options are required.
Error: 1995, Severity: 16, Cannot rebuild hypothetical index ‘%.*ls’ online.
Error: 1996, Severity: 16, 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.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *