SQL Server Errors

Incorrect syntax near the keyword ‘with’. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

Error Message: Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword ‘with’. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Severity level: 15. Description: This error message appears when you try to use a common table expression or […]

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

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

Cannot drop a message with an ID less than 50,000.

Error Message: Msg 15178, Level 16, State 1, Procedure sp_dropmessage, Line 25 Cannot drop a message with an ID less than 50,000. Severity level: 16. Description: This error message appears when you try to drop a system-defined message with an ID less than 50,000. Consequences: The T-SQL statement can be parsed, but causes the error […]

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