SQL Server Errors

A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.

Error Message:Msg 194, Level 15, State 1, Line 2A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable. Severity level:15. Description:This error message appears when you try to assign a value to a variable within a SELECT INTO statement. Consequences:The SQL statement cannot be parsed and further execution is stopped. […]

Cannot use a BREAK statement outside the scope of a WHILE statement.

Error Message:Msg 135, Level 15, State 1, Line 4Cannot use a BREAK statement outside the scope of a WHILE statement. Severity level:15. Description:This error message appears when you try to use a BREAK statement outside the scope of a WHILE loop. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the […]

Cannot use a CONTINUE statement outside the scope of a WHILE statement.

Error Message:Msg 136, Level 15, State 1, Line 4Cannot use a CONTINUE statement outside the scope of a WHILE statement. Severity level:15. Description:This error message appears when you try to use a CONTINUE statement outside the scope of a WHILE loop. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the […]

The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed for any data type (%d).

Error Message:Msg 131, Level 15, State 2, Line 3The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed for any data type (%d). Severity level:15. Description:This error message appears when you try to specify a size for a column that exceeds the maximum allowed size for any data type. Consequences:The SQL statement cannot […]

Can only use IF UPDATE within a CREATE TRIGGER statement.

Error Message:Msg 140, Level 15, State 1, Line 3Can only use IF UPDATE within a CREATE TRIGGER statement. Severity level:15. Description:This error message appears when you try to specify an IF UPDATE statement outside the scope of a trigger. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level […]

Invalid usage of the option %.*ls in the %ls statement.

Error Message:Msg 153, Level 15, State 1, Line 7Invalid usage of the option %.*ls in the %ls statement. Severity level:15. Description:This error message appears when you try to use an option in an invalid context. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level 15 are generated by […]

An aggregate may not appear in the set list of an UPDATE statement.

Error Message:Msg 157, Level 15, State 1, Line 2An aggregate may not appear in the set list of an UPDATE statement. Severity level:15. Description:This error message appears when you try to use an aggregate function in the SET list of an UPDATE statement. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

An aggregate may not appear in the OUTPUT clause.

Error Message:Msg 158, Level 15, State 1, Line 2An aggregate may not appear in the OUTPUT clause. Severity level:15. Description:This error message appears when you try to use an aggregate function in the OUTPUT clause of an UPDATE statement. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity […]

Each GROUP BY expression must contain at least one column that is not an outer reference.

Error Message:Msg 164, Level 15, State 1, Line 2Each GROUP BY expression must contain at least one column that is not an outer reference. Severity level:15. Description:This error message appears when you try to use only expressions in a GROUP BY clause that are interpreted as outer references. Consequences:The T-SQL statement can be parsed, but […]

Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.

Error Message:Msg 129, Level 15, State 1, Line 2Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100. Severity level:15. Description:This error message appears when you try to specify an invalid fillfactor in a CREATE/ALTER INDEX statement. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of […]
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 |