SQL Server Errors

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

Browse mode is invalid for statements containing a UNION, INTERSECT or EXCEPT operator.

Error Message: Msg 198, Level 15, State 1, Line 13 Browse mode is invalid for statements containing a UNION, INTERSECT or EXCEPT operator. Severity level: 15. Description: This error message appears when you try to use the browse mode in a statement containing a UNION, INTERSECT, or EXCEPT operator. Consequences: The SQL statement cannot be […]

The value %d specified for the MAXRECURSION option exceeds the allowed maximum of %d.

Error Message: Msg 310, Level 15, State 1, Line 29 The value %d specified for the MAXRECURSION option exceeds the allowed maximum of %d. Severity level: 15. Description: This error message appears when you try to use the MAXRECURSION option with a value that exceeds the allowed maximum. Consequences: The SQL statement cannot be parsed […]

The variable “%.*ls” is specified in the OPTIMIZE FOR clause, but is not used in the query.

Error Message: Msg 322, Level 16, State 1, Line 14 The variable “%.*ls” is specified in the OPTIMIZE FOR clause, but is not used in the query. Severity level: 16. Description: This error message appears when you try to use a variable in the OPTIMIZE FOR hint that is not used in the query. Consequences: […]

The %ls data type cannot be selected as DISTINCT because it is not comparable.

Error Message: Msg 421, Level 16, State 1, Line 7 The %ls data type cannot be selected as DISTINCT because it is not comparable. Severity level: 16. Description: This error message appears when you try to use the DISTINCT keyword on a data type that is not comparable. Consequences: The T-SQL statement can be parsed, […]

The FOR BROWSE clause is no longer supported in views. Set the database compatibility level to 80 or lower for this statement to be allowed.

Error Message: Msg 176, Level 15, State 1, Procedure, Line 8 The FOR BROWSE clause is no longer supported in views. Set the database compatibility level to 80 or lower for this statement to be allowed. Severity level: 15. Description: This error message appears when you try to use the browse mode in a view […]

Browse mode cannot be used with INSERT, SELECT INTO, or UPDATE statements.

Error Message: Msg 171, Level 15, State 1, Line 8 Browse mode cannot be used with INSERT, SELECT INTO, or UPDATE statements. Severity level: 15. Description: This error message appears when you try to use the browse mode in an INSERT, SELECT INTO, or UPDATE statement. Consequences: The SQL statement cannot be parsed and further […]

Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it is non-deterministic.

Error Message: Msg 2729, Level 16, State 1, Line 2 Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it is non-deterministic. Severity level: 16. Description: This error message appears when you try to use a non-deterministic column in a indec, statistic or as partition […]

Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

Error Message: Msg 130, Level 15, State 1, Line 3 Cannot perform an aggregate function on an expression containing an aggregate or a subquery. Severity level: 15. Description: This error message appears when you try to use an aggregate on an expression containing an aggregate or a subquery. Consequences: The T-SQL statement can be parsed, […]

Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.

Error Message: Msg 144, Level 15, State 1, Line 4 Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause. Severity level: 15. Description: This error message appears when you try to use an aggregate or a subquery in the group by list of […]