I need some help with this problem:

[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.

 

[JayKusch]

Why can't you do both in the same trigger???

Also, this is not the appropriate forum to post this question. You may want to post it in the SQL Server Programming forum. Of course, don't cross post.

Thanks

J. Kusch