SQL Server Errors

The ALTER TABLE SWITCH statement failed. The table “%.*ls” has a disabled clustered index.

Error Message: Msg 4985, Level 16, State 1, Line 4 The ALTER TABLE SWITCH statement failed. The table “%.*ls” has a disabled clustered index. Severity level: 16. Description: This error message appears when you try to execute an ALTER TABLE SWITCH command, for which one table has a disabled clustered index. Consequences: The T-SQL statement […]

Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column is non-deterministic.

Error Message: Msg 4936, Level 16, State 1, Line 1 Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column is non-deterministic. Severity level: 16. Description: This error message appears when you try to create a persisted computed column whose definition is non-deterministic. Consequences: The T-SQL statement can be parsed, but causes the […]

The READPAST lock hint is only allowed on target tables of UPDATE and DELETE and on tables specified in an explicit FROM clause.

Error Message: Msg 4102, Level 15, State 1, Line 6 The READPAST lock hint is only allowed on target tables of UPDATE and DELETE and on tables specified in an explicit FROM clause. Severity level: 15. Description: This error message appears when you try to use the READPAST hint on the target table of an […]

Partitioned view ‘%.*ls’ is not updatable because table ‘%.*ls’ has a timestamp column.

Error Message: Msg 4431, Level 16, State 1, Line 2 Partitioned view ‘%.*ls’ is not updatable because table ‘%.*ls’ has a timestamp column. Severity level: 16. Description: This error message appears when you try to update a UNION ALL view but at least one of the underlying base tables has a column of the timestamp […]

Cannot create %S_MSG on view “%.*ls” because it uses the aggregate COUNT. Use COUNT_BIG instead.

Error Message: Msg 10136, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it uses the aggregate COUNT. Use COUNT_BIG instead. Severity level: 16. Description: This error message appears when you try to use the aggregate COUNT in an indexed view. Consequences: The T-SQL statement can be parsed, but causes the […]

Cannot update partitioned view ‘%.*ls’ because the definition of the view column ‘%.*ls’ in table ‘%.*ls’ has a IDENTITY constraint.

Error Message: Msg 4450, Level 16, State 1, Line 2 Cannot update partitioned view ‘%.*ls’ because the definition of the view column ‘%.*ls’ in table ‘%.*ls’ has a IDENTITY constraint. Severity level: 16. Description: This error message appears when you try to update a UNION ALL view but at least one of the underlying base […]

Cannot create %S_MSG on view “%.*ls” because it contains one or more subqueries. Consider changing the view to use only joins instead of subqueries. Alternatively, consider not indexing this view.

Error Message: Msg 10136, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it contains one or more subqueries. Consider changing the view to use only joins instead of subqueries. Alternatively, consider not indexing this view. Severity level: 16. Description: This error message appears when you try to index a view […]

Partitioned view ‘%.*ls’ is not updatable because a value was not specified for partitioning column ‘%.*ls’.

Error Message: Msg 4435, Level 16, State 3, Line 2 Partitioned view ‘%.*ls’ is not updatable because a value was not specified for partitioning column ‘%.*ls’. Severity level: 16. Description: This error message appears when you try to insert into a partitioned view but do not provide a valkue for the partitioning column. Consequences: The […]

The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed (%d).

Error Message: Msg 2717, Level 16, State 1, Line 1 The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed (%d). Severity level: 16. Description: This error message appears when you exceed a maximum for a type declaration Consequences: The SQL statement cannot be parsed and further execution is stopped. Resolution: Errors of […]

Cannot INSERT into partitioned view ‘%.*ls’ because values were not supplied for all columns.

Error Message: Msg 4448, Level 16, State 17, Line 2 Cannot INSERT into partitioned view ‘%.*ls’ because values were not supplied for all columns. Severity level: 16. Description: This error message appears when you try to insert into a partitioned view but do not provide values for all columns. Consequences: The T-SQL statement can be […]
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 |