The Gurus Guide to SQL Server Stored Procedures, XML, and HTML [Electronic resources]

Disabling Triggers

You can disable a trigger via the ALTER TABLE…DISABLE TRIGGER command. Disabled triggers can be reenabled using ALTER TABLE…ENABLE TRIGGER. Here are a few examples (Listing 8-15):

Listing 8-15 Triggers can be disabled/enabled at will.

ALTER TABLE sales
DISABLE TRIGGER SalesQty_INSERT_UPDATE
ALTER TABLE sales
ENABLE TRIGGER SalesQty_INSERT_UPDATE
ALTER TABLE sales
DISABLE TRIGGER ALL
ALTER TABLE sales
ENABLE TRIGGER ALL