Disabling a Specified Trigger in MS SQL Server

90 Reads Ms Sql

To disable a TRIGGER specified in MS SQL Server, the following procedure is followed.

ALTER TABLE {Table Name} DISABLE TRIGGER {Trigger Name}
Ms Sql

You May Interest

Using MS SQL Order By

What is the XML Datatype in SQL Server ?

MS SQL Finding Which Tables a Column Name is In

What are the Different Recovery Models Inside SQL Server ?

What is the Use of Dedicated Admin Connection ?