Banks, credit unions, insurance companies,
How to remove all triggers to the SQL databases?
|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.