SQL Server Errors

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 [...]

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 [...]

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 [...]

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 [...]

Error Message: Msg 2224, Level 16, State 1, Line 4 %sAn expression was expected Severity level: 16. Description: This error message appears when an XQuery expression 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 [...]

Error Message: Msg 1979, Level 16, State 1, Line 2 Cannot use index option ignore_dup_key to alter index ‘%.*ls’ as it enforces a primary or unique constraint. Severity level: 16. Description: This error message appears when you try to alter an index to allow duplicate keys, but this index is used to enforce a PRIMARY [...]

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 [...]

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 [...]

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 [...]

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, [...]