SQL Server Errors

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

Must pass parameter number %d and subsequent parameters as ‘@name = value’. After the form ‘@name = value’ has been used, all subsequent parameters must be passed in the form ‘@name = value’.

Error Message:Msg 119, Level 15, State 1, Line 1Must pass parameter number %d and subsequent parameters as ‘@name = value’. After the form ‘@name = value’ has been used, all subsequent parameters must be passed in the form ‘@name = value’. Severity level:15. Description:This error message appears when you try to pass parameters in different […]

Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

Error Message:Msg 273, Level 16, State 1, Line 1Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column. Severity level:16. Description:This error message appears when insert an explicit value into a column if type TIMESTAMP. Consequences:The T-SQL […]

Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be an integer.

Error Message:Msg 477, Level 15, State 0, Line 1Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be an integer. Severity level:15. Description:This error message appears when you try to use a value of an invalid data type for the ROWS or REPEATABLE option of the […]

The name “%.*s” is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Error Message:Msg 128, Level 15, State 1, Line 5The name “%.*s” is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. Severity level:15. Description:This error message appears when you try to use an object name in an invalid context. Consequences:The T-SQL statement can […]

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

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

An aggregate may not appear in the OUTPUT clause.

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