SQL Server Triggers Question:
Download Questions PDF

What are the instances when triggers are appropriate?

Answer:

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.

Download MS SQL Server Triggers Interview Questions And Answers PDF

Previous QuestionNext Question
Explain trigger classes i.e. instead of and after trigger?What is MS SQL Server Triggers?