SQL Server Errors

The xml data type cannot be compared or sorted, except when using the IS NULL operator.

Error Message:Msg 305, Level 16, State 1, Line 2The xml data type cannot be compared or sorted, except when using the IS NULL operator. Severity level:16. Description:This error message appears when you try to group by a column of the data type XML. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

The valid range for MAX_QUEUE_READERS is 0 to 32767.

Error Message:Msg 187, Level 15, State 1, Line 6The valid range for MAX_QUEUE_READERS is 0 to 32767. Severity level:15. Description:This error message appears when you specify an invalid number for the MAX_QUEUE_READER option during a CREATE/ALTER QUEUE statement. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level 15 […]

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Error Message:Msg 306, Level 16, State 2, Line 2The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Severity level:16. Description:This error message appears when you try to group by a column of the data type TEXT, NTEXT, or IMAGE. Consequences:The T-SQL statement can be […]

An INSERT statement cannot contain a SELECT statement that assigns values to a variable.

Error Message:Msg 199, Level 15, State 1, Line 0An INSERT statement cannot contain a SELECT statement that assigns values to a variable. Severity level:15. Description:This error message appears when you try to use an INSERT statement that contains a SELECT statement, in which values are assigned to a variable. Consequences:The SQL statement cannot be parsed […]

Index ID %d on table ‘%.*ls’ (specified in the FROM clause) does not exist.

Error Message:Msg 307, Level 16, State 1, Line 1Index ID %d on table ‘%.*ls’ (specified in the FROM clause) does not exist. Severity level:16. Description:This error message appears when you try to specify an index that does not exist in an index hint. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

There are several reasons for this error. 1. Enable Remote Connection If you are using SQL Server 2005 Express or SQL Server Developer editions, you have to enable Remote connections. By default, SQL Server 2005 express, developer and evaluation editions allow local client connections only.             You must enable remote connections for each instance of […]

The MSSQLSERVER service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service

SQL Server agent does not start when the OS starts. When I try to start MSSQLSERVER in Services manually (even though it’s set for Automatic) I get “The MSSQLSERVER service on Local Computer started and then stopped.  Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts […]

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