SQL Server Errors

Only functions and extended stored procedures can be executed from within a function.

Error Message: Msg 557, Level 16, State 2, Line 2 Only functions and extended stored procedures can be executed from within a function. Severity level: 16. Description: This error message appears when you try to execute a normal stored procedure within a function. Consequences: The T-SQL statement can be parsed, but causes the error at […]

The %S_MSG name ‘%.*ls’ contains more than the maximum number of prefixes. The maximum is %d.

Error Message: Msg 117, Level 15, State 1, Line 4 The %S_MSG name ‘%.*ls’ contains more than the maximum number of prefixes. The maximum is %d. Severity level: 15. Description: This error message appears when you try to use more than the maximum allowed number of prefixes. Consequences: The SQL statement cannot be parsed and […]

Invalid parameter %d specified for %ls.

Error Message: Msg 1023, Level 15, State 1, Line 1 Invalid parameter %d specified for %ls. Severity level: 15. Description: This error message appears when you try to specify an invalid parameter to a procedure or function. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Error of the Severity […]

Browse mode is invalid for a statement that assigns values to a variable.

Error Message: Msg 114, Level 15, State 1, Line 8 Browse mode is invalid for a statement that assigns values to a variable. Severity level: 15. Description: This error message appears when you try to run a query that assigns values to a variable while being in browse mode. Consequences: The SQL statement cannot be […]

The SELECT item identified by the ORDER BY number %d contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.

Error Message: Msg 1008, Level 16, State 1, Line 10 The SELECT item identified by the ORDER BY number %d contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name. Severity level: 16. Description: This error message appears when you […]

An expression of non-boolean type specified in a context where a condition is expected, near ‘%.*ls’.

Error Message: Msg 4145, Level 15, State 1, Line 7 An expression of non-boolean type specified in a context where a condition is expected, near ‘%.*ls’. Severity level: 15. Description: This error message appears when you try to use a non-boolean expression in the context where a boolean expression is expected. Consequences: The SQL statement […]

The message number %u or specified language version does not exist.

Error Message: Msg 15179, Level 16, State 1, Procedure sp_dropmessage, Line 54 The message number %u or specified language version does not exist. Severity level: 16. Description: This error message appears when you try to drop a non-existing message. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Error of […]

The formal parameter “%.*ls” was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.

Error Message: Msg 8162, Level 16, State 2, Procedure , Line 0 The formal parameter “%.*ls” was not declared as an OUTPUT parameter, but the actual parameter passed in requested output. Severity level: 16. Description: This error message appears when you try to request an OUTPUT parameter from a stored procedure that was not declared […]

Explicit conversion from data type %ls to %ls is not allowed.

Error Message: Msg 529, Level 16, State 2, Line 3 Explicit conversion from data type %ls to %ls is not allowed. Severity level: 16. Description: This error message appears when you try to convert from one data type into another, but this conversion is not allowed. Consequences: The T-SQL statement can be parsed, but causes […]

User, group, or role ‘%s’ already exists in the current database.

Error Message: Msg 15023, Level 16, State 1, Line 2 User, group, or role ‘%s’ already exists in the current database. Severity level: 16. Description: This error message appears when you try to create a user, group, or role that already exists in the current database. Consequences: The T-SQL statement can be parsed, but causes […]
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 |