The Guru[ap]s Guide to SQL Server[tm] Stored Procedures, XML, and HTML
| for RuBoard |
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
| for RuBoard |