:::: MENU ::::

Ordering the triggers in SQL Server database

  • Jan 07 / 2010
  • 0
DBA Interview questions, dbDigger, Triggers

Ordering the triggers in SQL Server database

I have 3 UPDATE triggers on a individual table, TRA, TRB and TRC. Can I fire them in the sequence TRA, TRB and TRC?

Answer: Yes

Explanation:Using sp_settriggerorder Set TRA as first, TRC as LAST and TRB will fire between TRA and TRC firing which is what is desired.

Note: The question of day is taken from SqlServerCentral.com. I want to compile selected QOD to share.

Consult us to explore the Databases. Contact us