SQL Server Errors

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

Operand type clash: %ls is incompatible with %ls

Error Message:Msg 206, Level 16, State 2, Line 1Operand type clash: %ls is incompatible with %ls Severity level:16. Description:This error message appears when you try to use two incompatible operands in an operator. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity level 16 are generated by the […]

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

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