SQL Server Triggers Question:
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.
When backups are essential
When Maintenance is desired. Triggers can be fired when any error message is logged
Keeping the database consistent.
| Previous Question | Next Question |
| Explain trigger classes i.e. instead of and after trigger? | What is MS SQL Server Triggers? |