How to remove all triggers to the SQL databases?

Email It to Me Print this Page
Question How to remove all triggers from SQL databases?
Answer To remove all triggers from audited databases you need to run the following script located in the product installation directory: sqlcr_remove_audit_from_db.sql 
If you execute it against the database in SQL Management Studio, it will remove all triggers.

Note: You need to specify the name of the database from which you'd like to remove the triggers in the following line: 
USE [ ] -- specify the name of the database from which you want to remove the objects created to audit data.
(*) Netwrix Auditor replaces former Change Reporter products
Was this information helpful?