SQL Server Errors or Failures Error: 1997 to Error: 2104
Error: 1997, Severity: 16,
Could not convert the XML or spatial index ‘%.*ls’ to a relational index by using the DROP_EXISTING option. Drop the XML or spatial index and create a relational index with the same name.
Error: 1998, Severity: 10,
Warning: Clustered index ‘%.*ls’ on view ‘%.*ls’ referencing table ‘%.*ls’ was disabled as a result of disabling the index ‘%.*ls’.
Error: 1999, Severity: 16,
Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as included column in an index.
Error: 2002, Severity: 16,
Cannot create a procedure for replication with group number greater than one.
Error: 2003, Severity: 16,
Procedures with a group number cannot have parameters of XML or CLR types. Parameter ‘%.*ls’ of procedure ‘%.*ls’ has type ‘%ls’.
Error: 2004, Severity: 16,
Procedure ‘%.*ls’ has already been created with group number %d. Create procedure with an unused group number.
Error: 2005, Severity: 16,
The table ‘%.*ls’ is unavailable and needs to be rebuilt. Rebuild the table offline.
Error: 2007, Severity: 10,
The module ‘%.*ls’ depends on the missing object ‘%.*ls’. The module will still be created; however, it cannot run successfully until the object exists.
Error: 2008, Severity: 16,
The object ‘%.*ls’ is not a procedure so you cannot create another procedure under that group name.
Error: 2010, Severity: 16,
Cannot perform alter on ‘%.*ls’ because it is an incompatible object type.
Error: 2011, Severity: 16,
Index hints cannot be specified within a schema-bound object.
Error: 2013, Severity: 10,
Warning: ‘is_ms_shipped’ property is turned off for %S_MSG ‘%.*ls’ because you do not have permission to create or alter an object with this property.
Error: 2014, Severity: 16,
Remote access is not allowed from within a schema-bound object.
Error: 2020, Severity: 16,
The dependencies reported for entity “%.*ls” might not include references to all columns. This is either because the entity references an object that does not exist or because of an error in one or more statements in the entity. Before rerunning the quer
Error: 2021, Severity: 16,
The referenced entity ‘%.*ls’ was modified during DDL execution. Please retry the operation.
Error: 2022, Severity: 16,
Parsing errors were encountered in the %S_MSG ‘%.*ls’. The dependencies referenced from this object could not be determined.
Error: 2101, Severity: 14,
Cannot %S_MSG a server level %S_MSG for user ‘%.*ls’ since there is no login corresponding to the user.
Error: 2102, Severity: 16,
Cannot %S_MSG %S_MSG ‘%.*ls’ since there is no user for login ‘%.*ls’ in database ‘%.*ls’.
Error: 2103, Severity: 15,
Cannot %S_MSG trigger ‘%.*s’ because its schema is different from the schema of the target table or view.
Error: 2104, Severity: 14,
Cannot %S_MSG the %S_MSG ‘%.*ls’, because you do not have permission.
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.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.