SQL Server Errors

DISTINCT operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error Message:Msg 460, Level 16, State 1, Line 1DISTINCT operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’. Severity level:16. Description:This error message appears when you try to use the DISTINCT operator in the recursive part of a Common Table Expression. Consequences:The T-SQL statement can be parsed, but causes […]

Types don’t match between the anchor and the recursive part in column “%.*ls” of recursive query “%.*ls”.

Error Message:Msg 240, Level 16, State 1, Line 1Types don’t match between the anchor and the recursive part in column “%.*ls” of recursive query “%.*ls”. Severity level:16. Description:This error message appears when data types of a column in the anchor and the recursive part of a Common Table Expression are incompatible. Consequences:The T-SQL statement can […]

TOP operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error Message:Msg 461, Level 16, State 1, Line 1TOP operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’. Severity level:16. Description:This error message appears when you try to use the TOP operator in the recursive part of a Common Table Expression. Consequences:The T-SQL statement can be parsed, but causes […]

Recursive common table expression ‘%.*ls’ does not contain a top-level UNION ALL operator.

Error Message:Msg 252, Level 16, State 1, Line 1Recursive common table expression ‘%.*ls’ does not contain a top-level UNION ALL operator. Severity level:16. Description:This error message appears when a Common Table Expression does not contain a top-level UNION ALL operator. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

Outer join is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error Message:Msg 462, Level 16, State 1, Line 1Outer join is not allowed in the recursive part of a recursive common table expression ‘%.*ls’. Severity level:16. Description:This error message appears when you try to use an OUTER JOIN in the recursive part of a Common Table Expression. Consequences:The T-SQL statement can be parsed, but causes […]

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

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