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