What are the instances when triggers are appropriate?

Submitted by: Administrator
When security is the top most priority. i.e. to allow unauthorized access
When backups are essential
When Maintenance is desired. Triggers can be fired when any error message is logged
Keeping the database consistent.
Submitted by: Administrator

Read Online SQL Server Triggers Job Interview Questions And Answers