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 <trigger name> ON <table name>
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.