Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-16 : 09:38:43
|
| Sunil K writes "I have written a pair of insert and update triggers on a table that has already got a few business triggers.I want to ensure that the triggers that I had written shall fire at last and only after all the triggers had already executed.I have delared both the insert and update trigger to be the last in their respective orders.Presently, my update trigger is getting fired for every business triggers that updates the table while we wanted that our update trigger shall fire only after all the business triggers up in the sequence had fired.Please suggest a work around for this as it's a bit critical for our business environment." |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-08-16 : 09:43:49
|
| I think you can use this store procedure sp_settriggerorder please check book online Specifying First and Last TriggersThanksSanjeev Shrestha12/17/1971 |
 |
|
|
|
|
|
Trigger Sequence in SQL Server