SQL Server Errors

UNION ALL view ‘%.*ls’ is not updatable because column ‘%.*ls’ of base table ‘%.*ls’ is used multiple times.

Error Message: Msg 4443, Level 16, State 8, Line 1 UNION ALL view ‘%.*ls’ is not updatable because column ‘%.*ls’ of base table ‘%.*ls’ is used multiple times. Severity level: 16. Description: This error message appears when you try to update a UNION ALL view but at least one column of an underlying base table […]

UNION ALL view ‘%.*ls’ is not updatable because the primary key of table ‘%.*ls’ is not unioned with primary keys of preceding tables.

Error Message: Msg 4445, Level 16, State 11, Line 1 UNION ALL view ‘%.*ls’ is not updatable because the primary key of table ‘%.*ls’ is not unioned with primary keys of preceding tables. Severity level: 16. Description: This error message appears when you try to update a UNION ALL view but at least one primary […]

Index ‘%.*ls’ on table ‘%.*ls’ (specified in the FROM clause) does not exist.

Error Message: Msg 308, Level 16, State 1, Line 3 Index ‘%.*ls’ on table ‘%.*ls’ (specified in the FROM clause) does not exist. Severity level: 16. Description: This error message appears when you try to force the usage of a non-existing index. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. […]

Cannot set or reset the ‘parseonly’ option within a procedure or function.

Error Message: Msg 1059, Level 15, State 1, Procedure, Line 0 Cannot set or reset the ‘parseonly’ option within a procedure or function. Severity level: 15. Description: This error message appears when you try to use the ‘parseonly’ option in a procedure or function. Consequences: The SQL statement cannot be parsed and further execution is […]

Cannot use index “%.*ls” on table “%.*ls” in a hint. XML indexes are not allowed in hints.

Error Message: Msg 309, Level 16, State 1, Line 1 Cannot use index “%.*ls” on table “%.*ls” in a hint. XML indexes are not allowed in hints. Severity level: 16. Description: This error message appears when you try to force the usage of an XML index in a hint. Consequences: The T-SQL statement can be […]

The NOLOCK and READUNCOMMITTED lock hints are not allowed for target tables of INSERT, UPDATE or DELETE statements.

Error Message: Msg 1065, Level 15, State 5, Line 15 The NOLOCK and READUNCOMMITTED lock hints are not allowed for target tables of INSERT, UPDATE or DELETE statements. Severity level: 15. Description: This error message appears when you try to run a INSERT, UPDATE, or DELETE statement in the transaction isolation level READUNCOMMITTED or use […]

Index “%.*ls” on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online.

Error Message: Msg 315, Level 16, State 1, Line 11 Index “%.*ls” on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online. Severity level: 16. Description: This error message appears when you try to force the usage of an index in a hint, but this index […]

‘%.*ls’ is an invalid event type.

Error Message: Msg 1084, Level 15, State 1, Procedure, Line 2 ‘%.*ls’ is an invalid event type. Severity level: 15. Description: This error message appears when you specify an invalid event in a trigger. Consequences: The SQL statement cannot be parsed and further execution is stopped. Resolution: Errors of the Severity Level 15 are generated […]

The index ID %d on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online.

Error Message: Msg 316, Level 16, State 1, Line 11 The index ID %d on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online. Severity level: 16. Description: This error message appears when you try to force the usage of an index via the internal index […]

Column ‘%.*ls.%.*ls’ is not of same collation as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’.

Error Message: Msg 1757, Level 16, State 0, Line 4 Column ‘%.*ls.%.*ls’ is not of same collation as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’. Severity level: 16. Description: This error message appears when you try to define a foreign key constraing on columns having different collations. 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 |