[Script Of Apr. 13] How to disable all the triggers in a SQL Server database

image

Apr.

13

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-disable-all-the-03a79962.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This script is to disable all the triggers in a SQL Server database.

Sometimes, people want to disable all the triggers in a database for some reason. It will be a heavy task to check if the triggers in tables are disabled or not one by one. This script will help find all the triggers in all the tables in a database, and it will generate the following items:

a table to show the status of all the triggers

code in Messages panel to disable all the triggers in Enable status

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery