SQL Server Errors

ALTER TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist.

Error Message: Msg 4920, Level 16, State 0, Line 6 ALTER TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist. Severity level: 16. Description: This error message appears when you try to perform an action (enable, disable, etc) for a trigger via an ALTER TABLE statement, but the trigger does not exist. Consequences: […]

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld.

Error Message: Msg 266, Level 16, State 2, Procedure, Line 0 Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld. Severity level: 16. Description: This error message appears when you try to execute a procedure, but the transaction count before and after the […]

ALTER TABLE failed because trigger ‘%.*ls’ does not belong to table ‘%.*ls’.

Error Message: Msg 4921, Level 16, State 0, Line 2 ALTER TABLE failed because trigger ‘%.*ls’ does not belong to table ‘%.*ls’. Severity level: 16. Description: This error message appears when you try to perform an action (enable, disable, etc) for a trigger via an ALTER TABLE statement, but the trigger does not belong to […]

The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

Error Message: The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. Severity level: 10. Description: This informational error message appears […]

ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a column level check constraint ‘%.*ls’ but the source table ‘%.*ls’ does not have a corresponding constraint.

Error Message: Msg 4971, Level 16, State 1, Line 2 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a column level check constraint ‘%.*ls’ but the source table ‘%.*ls’ does not have a corresponding constraint. Severity level: 16. Description: This error message appears when you try to execute an ALTER TABLE SWITCH command, for […]

The logical tables INSERTED and DELETED cannot be updated.

Error Message: Msg 286, Level 16, State 1, Procedure, Line 5 The logical tables INSERTED and DELETED cannot be updated. Severity level: 16. Description: This error message appears when you update the logical tables INSERTED and DELETED in a trigger. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Error […]

FIPS Warning: Line %d has the non-ANSI statement ‘%ls’.

Error Message: FIPS Warning: Line %d has the non-ANSI statement ‘%ls’. FIPS Warning: Line %d has the non-ANSI statement ‘%ls’. Severity level: 10. Description: This informational error message appears when you try to use a non-ANSI compliant statement while the FIPS FLAGGER is activated. Consequences: Resolution: Error of this severity level are informational errors that […]

Cannot create %S_MSG on view ‘%.*ls’ because it contains one or more UNION, INTERSECT, or EXCEPT operators. Consider creating a separate indexed view for each query that is an input to the UNION, INTERSECT, or EXCEPT operators of the original view.

Error Message: Msg 10116, Level 16, State 1, Line 2 Cannot create %S_MSG on view ‘%.*ls’ because it contains one or more UNION, INTERSECT, or EXCEPT operators. Consider creating a separate indexed view for each query that is an input to the UNION, INTERSECT, or EXCEPT operators of the original view. Severity level: 16. Description: […]

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide.

Error Message: Msg 10509, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide. Provide a single valid Transact-SQL statement or a valid starting position of the statement within the batch. To […]

FIPS Warning: Line %d has the non-ANSI clause ‘%ls’.

Error Message: FIPS Warning: Line %d has the non-ANSI clause ‘%ls’. FIPS Warning: Line %d has the non-ANSI clause ‘%ls’. Severity level: 10. Description: This informational error message appears when you try to use a non-ANSI compliant statement while the FIPS FLAGGER is activated. Consequences: Resolution: Error of this severity level are informational errors that […]
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 |