Accessing Insert And Delete tables outside of a Trigger

[webuser]

I need to be able to run a stored procedure from a trigger. I would like the Stored Procedure to access the Inserted And Deleted Tables. Is there any way to do this, other that Inserting all the records into a temporary table...which works, but in my opinion is not so elegant. Can you maybe pass the tables as a parameter of some sort?

Any help would be appreciated.
Thanks in advance...

 

[vishnuprasad]

Well u can pass a cursor instead of a temp table, but u will not be able to access the inserted and deleted tables outside this trigger.

So go for optimised cursor properties and pass the cursor.

 

[webuser]

From what I understand, there is no way to passa Cursor as an Input Parameter to a Stored Procedure...Is this what you meant?