SQL Server Errors

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

The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.

Error Message:Msg 288, Level 16, State 1, Line 3The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only. Severity level:16. Description:This error message appears when you try to non-character values in the string function PATINDEX. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of 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 […]

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

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