SQL Server Errors

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

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

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

Cannot use HOLDLOCK in browse mode.

Error Message: Msg 172, Level 15, State 1, Line 6 Cannot use HOLDLOCK in browse mode. Severity level: 15. Description: This error message appears when you try to use the HOLDLOCK locking hint in browse mode. Consequences: The SQL statement cannot be parsed and further execution is stopped. Resolution: Error of the Severity level 15 […]

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