Howtos / Articles

Enable and Disable Triggers in Microsoft SQL Server

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.

Share this howto article!
  • Facebook
  • Twitter
  • Reddit
  • email

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>