Get value of parameters passed in stored procedure in a trigger

microsoft.public.sqlserver.programming

1 Oct 2005 11:00 AM

manK

In updating my tables (insert/update), i use stored procedures.

Some of the values passed as parameters to the stored procedures
are only necessary for audit trail only and not for updating the tables.

How can i get hold of these parameter values while inside a trigger?

1 Oct 2005 11:41 AM

David Portas

Put the parameters in a permanent table or a local temp table.

--
David Portas
SQL Server MVP
--

Show quote

"manK" <m***@discussions.microsoft.com> wrote in message
news:EA0833BF-A070-4720-9E50-9C80EAE45FF9@microsoft.com...
> In updating my tables (insert/update), i use stored procedures.
>
> Some of the values passed as parameters to the stored procedures
> are only necessary for audit trail only and not for updating the tables.
>
> How can i get hold of these parameter values while inside a trigger?
>