SQL Server Errors

UNION ALL view ‘%.*ls’ is not updatable because a partitioning column was not found.

Error Message: Msg 4436, Level 16, State 12, Line 1 UNION ALL view ‘%.*ls’ is not updatable because a partitioning column was not found. Severity level: 16. Description: This error message appears when you try to update a UNION ALL view ut no partitioning column was found. Consequences: The T-SQL statement can be parsed, but […]

UNION ALL view ‘%.*ls’ is not updatable because a primary key was not found on table ‘%.*ls’.

Error Message: Msg 4440, Level 16, State 9, Line 1 UNION ALL view ‘%.*ls’ is not updatable because a primary key was not found on table ‘%.*ls’. Severity level: 16. Description: This error message appears when you try to update a UNION ALL view but at least one underlying base table does not have a […]

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

The target table ‘%.*ls’ of the OUTPUT INTO clause cannot have any enabled triggers.

Error Message: Msg 331, Level 16, State 1, Line 2 The target table ‘%.*ls’ of the OUTPUT INTO clause cannot have any enabled triggers. Severity level: 16. Description: This error message appears when you try to use the OUTPUT INTO clause for a target table which has triggers enabled. Consequences: The T-SQL statement can be […]

Cannot create the foreign key “%.*ls” with the SET NULL referential action, because one or more referencing columns are not nullable.

Error Message: Msg 1761, Level 16, State 0, Line 3 Cannot create the foreign key “%.*ls” with the SET NULL referential action, because one or more referencing columns are not nullable. Severity level: 16. Description: This error message appears when you try to create a foreign key constraint with the referential SET NULL action, but […]

The target table ‘%.*ls’ of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint ‘%ls’.

Error Message: Msg 332, Level 16, State 1, Line 6 The target table ‘%.*ls’ of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint ‘%ls’. Severity level: 16. Description: This error message appears when you try to use the OUTPUT INTO clause for a target […]

Cannot create the foreign key “%.*ls” with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint.

Error Message: Msg 1762, Level 16, State 0, Line 3 Cannot create the foreign key “%.*ls” with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint. Severity level: 16. Description: This error message appears when you try to create a foreign key constraint with the referential SET DEFAULT […]

The TABLESAMPLE clause can only be used with local tables.

Error Message: Msg 494, Level 16, State 1, Line 4 The TABLESAMPLE clause can only be used with local tables. Severity level: 16. Description: This error message appears when you try to use the TABLESAMPLE clause with a non-local table. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors […]
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 |