How to start and stop triggers in sql server?

Tags : Enable Trigger,Disable Trigger,SQL Server 2005,SQL Server 2008,Triggers,Start,Stop.

Hi Friends,in this post i would like to explain enabling and disabling triggers in SQL Server.

* By writing Commands we can Start/Stop triggers in SQL Server.


Enabling/Starting Trigger :

Enable Trigger TriggerName ON database.dbo.tablename


Disabling/Stopping Trigger :

Disable Trigger TriggerName ON database.dbo.tablename


Thank You...