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:
The T-SQL statement can be parsed, but causes the error at runtime. Resolution:
Errors of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. The statement cannot be executed this way. The trigger must exist and belong to that table. Versions:
This error message was introduced with SQL Server 2005. Example(s):
IF OBJECT_ID (‘dbo.t’) IS NOT NULL
    DROP TABLE dbo.t;
GO
CREATE TABLE dbo.t
(
    c1 int
); ALTER TABLE dbo.t
    DISABLE TRIGGER t_nonexisting_trigger Remarks:
In the above example we try to disable a non-existing trigger on table dbo.t. This raises the error. ]]>

Leave a comment

Your email address will not be published.