Syntax to disable trigger

Home >> Dababase Interview Questions >> Sql Server Interview Questions

Posted on December 15th , 2011 by Admin

Below is the syntax to disable single trigger on the database

DISABLE TRIGGER triggerName ON TableName

and below is the syntax to disable all the trigger on to the server

DISABLE Trigger ALL ON ALL SERVER