>>Is there a way to know which trigger called my SP? Update,Delete,New? Or is the only way to query the Insert and Delete tables and determine from there record counts?
>
>I don't think there's any way without passing some info from the trigger.
>
>BTW, are the deleted and inserted tables visible to a stored procedure that is called from within a trigger?

According to the MS-SQL Server self study training course I have they are.

>Also, are you sure that you want to call a stored procedure from within the trigger? Remember that a trigger will fire no matter how many rows were affected by the query.
>
>-Mike

Yep... that's what I need. Thanks for the help.

BOb