[Script Of Apr. 13] How to disable all the triggers in a SQL Server database
Apr.
13
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