Calling SP from Trigger (preserving INSTEAD)

[gaffonso]

I've got a trigger written (thanks Terry) that's logging INSERT, UPDATE, and DELETE activity on my table.

I'd like to re-use this trigger code on all my tables so I thought that putting it into a stored procedure and passing table-specific data from the trigger would be the ideal way to do this.

The problem is that the INSERTED, and DELETED temporary tables available in a trigger do not appear to be available in the stored procedure called from a trigger. They play an integral role in the algorithm used to log audit data.

Any idea how I might gain access tot he INSERTED and DELETED tables via a SP called from a trigger?

Thanks!

- Gary