SQL Server Errors

Cannot use DROP %ls with ‘%.*ls’ because ‘%.*ls’ is a %S_MSG. Use DROP %ls.

Error Message:Msg 3705, Level 16, State 1, Line 6Cannot use DROP %ls with ‘%.*ls’ because ‘%.*ls’ is a %S_MSG. Use DROP %ls. Severity level:16. Description:This error message appears when you try to execute a DROP command for an object of the wrong object type. Consequences:The T-SQL statement can be parsed, but causes the error at […]

The function ‘%.*ls’ takes exactly %d argument(s).

Error Message:Msg 4114, Level 15, State 1, Line 1The function ‘%.*ls’ takes exactly %d argument(s). Severity level:15. Description:This error message appears when you try to call a windowed fucntion without providing the exact number of arguments for that function. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Errors of the Severity Level […]

Cannot create nonunique clustered index on view ‘%.*ls’ because only unique clustered indexes are allowed. Consider creating unique clustered index instead.

Error Message:Msg 1941, Level 16, State 1, Line 2Cannot create nonunique clustered index on view ‘%.*ls’ because only unique clustered indexes are allowed. Consider creating unique clustered index instead. Severity level:16. Description:This error message appears when you try to create a non-unique clustered index on a view. Consequences:The T-SQL statement can be parsed, but causes […]

Index hints cannot be specified within a schema-bound object.

Error Message:Msg 2011, Level 16, State 1, Procedure MyOrderView, Line 4Index hints cannot be specified within a schema-bound object. Severity level:16. Description:This error message appears when you try to use an index hint within a schema-bound object. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 […]

Cannot create %S_MSG on view “%.*ls”. The view contains a self join on “%.*ls”.

Error Message:Msg 1947, Level 16, State 1, Line 2Cannot create %S_MSG on view “%.*ls”. The view contains a self join on “%.*ls”. Severity level:16. Description:This error message appears when you try to create an indexed view that contains a self-join. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

Cannot find a table or object with the name “%.*ls”. Check the system catalog.

Error Message:Msg 2501, Level 16, State 45, Line 1Cannot find a table or object with the name “%.*ls”. Check the system catalog. Severity level:16. Description:This error message appears when you try to use a non-existant database object in a DBCC command. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of […]

Cannot create %S_MSG on view ‘%.*ls’. The function ‘%s’ yields nondeterministic results. Use a deterministic system function, or modify the user-defined function to return deterministic results.

Error Message:Msg 1949, Level 16, State 1, Line 2Cannot create %S_MSG on view ‘%.*ls’. The function ‘%s’ yields nondeterministic results. Use a deterministic system function, or modify the user-defined function to return deterministic results. Severity level:16. Description:This error message appears when you try to create an indexed view that contains a nondeterministic function. Consequences:The T-SQL […]

The CONCAT_NULL_YIELDS_NULL option must be set to ON to run DBCC CHECKCONSTRAINTS.

Error Message:Msg 2501, Level 16, State 45, Line 1The CONCAT_NULL_YIELDS_NULL option must be set to ON to run DBCC CHECKCONSTRAINTS. Severity level:16. Description:This error message appears when you try to use the DBCC CHECKCONSTRAINTS command while the CONCAT_NULL_YIELDS_NULL option is deactivated. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of […]

Cannot create an index on a view or computed column because the compatibility level of this database is less than 80. Use sp_dbcmptlevel to raise the compatibility level of the database.

Error Message:Msg 1959, Level 16, State 1, Line 2Cannot create an index on a view or computed column because the compatibility level of this database is less than 80. Use sp_dbcmptlevel to raise the compatibility level of the database. Severity level:16. Description:This error message appears when you try to create an indexed view that is […]

Parameter %d is incorrect for this DBCC statement.

Error Message:Msg 2560, Level 16, State 9, Line 1Parameter %d is incorrect for this DBCC statement. Severity level:16. Description:This error message appears when you try to use an invalid parameter or parameter value for a specific DBCC command. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level […]