SQL Server Errors

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 Message: Msg 1990, Level 16, State 1, Line 2 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. Severity level: 16. Description: This error message appears when you try to create or alter an index […]

%sThe variable ‘%ls’ was not found in the scope in which it was referenced.

Error Message: Msg 2227, Level 16, State 1, Line 6 %sThe variable ‘%ls’ was not found in the scope in which it was referenced. Severity level: 16. Description: This error message appears when you try to specify a variable in an Xquery, but this variable was not found in the scope in which it was […]

%sThere is no function ‘%ls:%ls()’

Error Message: Msg 2395, Level 16, State 1, Line 7 %sThere is no function ‘%ls:%ls()’ Severity level: 16. Description: This error message appears when you try to use an unknown XQuery function. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Error of the Severity level 16 are generated by […]

%s’%ls’ or ‘%ls’ expected

Error Message: Msg 2217, Level 16, State 1, Line 7 %s’%ls’ or ‘%ls’ expected Severity level: 16. Description: This error message appears when an expected element of an XQuery was not found. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity level 16 are generated by […]

%sSyntax error near ‘%ls’, expected ‘where’, ‘(stable) order by’ or ‘return’.

Error Message: Msg 9332, Level 16, State 1, Line 5 %sSyntax error near ‘%ls’, expected ‘where’, ‘(stable) order by’ or ‘return’. Severity level: 16. Description: This error message appears when a syntax error is encountered in an XQuery. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the […]

%s”%ls” was expected.

Error Message: Msg 2205, Level 16, State 1, Line 4 %s”%ls” was expected. Severity level: 16. Description: This error message appears when a particular XQuery keyword was expected, but not found. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity level 16 are generated by the […]

There is no user table matching the input name ‘%s’ in the current database or you do not have permission to access the table.

Error Message: Msg 15388, Level 11, State 1, Procedure sp_indexoption, Line 101 There is no user table matching the input name ‘%s’ in the current database or you do not have permission to access the table. Severity level: 11. Description: This error message appears when you try to use the sp_indexoption system stored procedure, but […]

Cannot recreate index ‘%.*ls’. The new index definition does not match the constraint being enforced by the existing index.

Error Message: Msg 1907, Level 16, State 1, Line 2 Cannot recreate index ‘%.*ls’. The new index definition does not match the constraint being enforced by the existing index. Severity level: 16. Description: This error message appears when you try recreate an index, but the new index definition does not match the constraint that is […]

Cannot convert a nonclustered index to a clustered index online using DROP_EXISTING option.

Error Message: Msg 1968, Level 16, State 1, Line 2 Cannot convert a nonclustered index to a clustered index online using DROP_EXISTING option. Severity level: 16. Description: This error message appears when you try to convert a nonclustered index to a clustered index by using the DROP_EXISTING option. Consequences: The T-SQL statement can be parsed, […]

Index ‘%.*ls’ was not created. This index has a key length of at least %d bytes. The maximum permissible key length is %d bytes.

Error Message: Msg 1944, Level 16, State 1, Line 6 Index ‘%.*ls’ was not created. This index has a key length of at least %d bytes. The maximum permissible key length is %d bytes. Severity level: 16. Description: This error message appears when you try to create an index on a set of columns that […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |