Send Knowledge Base Article
The article has been sent to your inbox successfully.
We never share your data
How to remove all triggers to the SQL databases?
KB1637 | Last review: Jun 19, 2013 | Netwrix Auditor for SQL Server | 2.6.194 and above
|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.
Was this information helpful?