SQL Server Errors

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

Recursive member of a common table expression ‘%.*ls’ has multiple recursive references.

Error Message:Msg 253, Level 16, State 1, Line 1Recursive member of a common table expression ‘%.*ls’ has multiple recursive references. Severity level:16. Description:This error message appears when the recursive part of a Common Table Expression has more than one recursive reference. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of […]

Invalid PERCENT tablesample size “%f” for table “%.*ls”. The PERCENT tablesample size must be between 0 and 100.

Error Message:Msg 476, Level 15, State 0, Line 1Invalid PERCENT tablesample size “%f” for table “%.*ls”. The PERCENT tablesample size must be between 0 and 100. Severity level:15. Description:This error message appears when you try to use an invalid percent value in the TABLESAMPLE clause. Consequences:The T-SQL statement can be parsed, but causes the error […]

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

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

An aggregate may not appear in the set list of an UPDATE statement.

Error Message:Msg 157, Level 15, State 1, Line 2An aggregate may not appear in the set list of an UPDATE statement. Severity level:15. Description:This error message appears when you try to use an aggregate function in the SET list of an UPDATE statement. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]
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 |