"

How to remove all triggers from SQL Server database?

Last review: Jun 06, 2013
https://kb.netwrix.com/817
Copy Article URL Copied

How to remove all triggers from SQL Server database?


In order to remove all triggers from audited database(s) you should execute the script located at the installation folder of Netwrix Auditor:

C:\Program Files (x86)\Netwrix Auditor\SQL Server Auditing\sqlcr_remove_audit_from_db.sql

Note: Before executing the script, you should specify the name of the database where you would like to remove the triggers at “Available Databases” listbox.

 

Go Up