Multiple Triggers 2

[cass60660]

I need some help with this problem:
Can I create 2 triggers (FOR INSERT) on the same table ?
If yes, which one is going to fire first ?
One trigger (TR1) is validating the data and second trigger (TR2) is inserting in a log table the activity (in this case new rows).
If is possible to have 2 triggers (FOR INSERT) how can I establish the order ?

-I use: SQL Server 2000

Thank you.

 

[TitleistDBA]

You can put both of that logic in 1 trigger.

http://www.acushnetcompany.com

 

[cass60660]

I was thinking about that BUT the first trigger is returning to me (to the application) some warnings, messages and errors.

 

[TitleistDBA]

And to answer your question, yes you can have more than one insert trigger on a table. The triggers I created fired in the order I created them.

http://www.acushnetcompany.com

 

[JamesLean]

You can have multiple AFTER INSERT triggers on a table (but only one INSTEAD OF INSERT trigger).

You can set which triggers fire first and last using sp_settriggerorder. Any others will fire in an undefined order between them.

--James