Networking HowTos
Networking HowTos

Enable and Disable Triggers in Microsoft SQL Server

November 30, 2012 Database, Microsoft SQL

The Microsoft SQL database server supports the use of Triggers on its tables. Triggers are a special kind of stored procedure that can be executed when records in a table are either inserted, updated, or deleted.

Sometimes you may want to temporarily disable a trigger without completely removing it. The steps to do this, and enable the trigger again, are outlined below.
Disable Trigger:

DISABLE TRIGGER <trigger name> ON <table name>

Enable Trigger:

ENABLE TRIGGER <trigger name> ON <table name>

Replace <trigger name> with the name of the trigger you wish to enable or disable.
Replace <table name> with the name of the table that the trigger is linked to.

You Might Also Like