How to enable and disable trigger in SQL server

Lincoln Burrows ~ Modified: December 10th, 2015 ~ ~ 1 Minute Reading

This topic has 3 replies, 3 voices, and was last updated 9 years, 10 months ago by Stephen West.

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts
December 10, 2015 at 12:24 pm #994 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

Is there any way to enable and disable SQL Server triggers?

December 19, 2015 at 12:17 pm #1005 Score: 0
Andrew Jackson
Moderator

Karma: 1 pt
To disable / enable selective triggers…
```
ALTER TABLE tableName DISABLE TRIGGER triggername
ALTER TABLE tableName ENABLE TRIGGER triggername
```
To disable / enable all triggers…
```
ALTER TABLE tableName DISABLE TRIGGER ALL
ALTER TABLE tableName ENABLE TRIGGER ALL 
```
December 21, 2015 at 12:40 pm #1007 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

Thanks Andrew for the script, it works great, but I also want to know can I enable and disable SQL Server Trigger using SQL Server Management Studio (GUI).

December 22, 2015 at 12:40 pm #1008 Score: 0

Stephen West
Moderator

Karma: 4 pts

I have found an informative article that shows how to enable and disable indexes in SQL Server using SQL Server Management Studio and Transact-SQL hope this will help you out, see from here: http://www.sqlserverlogexplorer.com/enable-and-disable-indexes/
Author

Posts

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.