>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?
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