SQL Server Errors

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

The IDENTITY function can only be used when the SELECT statement has an INTO clause.

Error Message:Msg 177, Level 15, State 1, Line 1The IDENTITY function can only be used when the SELECT statement has an INTO clause. Severity level:15. Description:This error message appears when you try to use the IDENTITY function without the scope of a SELECT INTO statement Consequences:The SQL statement cannot be parsed and further execution is […]

The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure.

Error Message:Msg 132, Level 15, State 1, Line 11The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure. Severity level:15. Description:This error message appears when you try to specify a label more than once. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error […]

Cannot specify a log file in a CREATE DATABASE statement without also specifying at least one data file.

Error Message:Msg 188, Level 15, State 1, Line 2Cannot specify a log file in a CREATE DATABASE statement without also specifying at least one data file. Severity level:15. Description:This error message appears when you try to specify a log file in a CREATE DATABASE statement, without specifying at least one data file. Consequences:The SQL statement […]

A GOTO statement references the label ‘%.*ls’ but the label has not been declared.

Error Message:Msg 133, Level 15, State 1, Line 10A GOTO statement references the label ‘%.*ls’ but the label has not been declared. Severity level:15. Description:This error message appears when you try to reference a label which has not been declared yet Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the […]

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