Session Variable For A Sequel Trigger

Is there away to capture a session variable value from IIS
and use it in a SQL 2000 trigger with out passing it as a
part of a string query. I just want to capture it somehow
systemically.

Thanks,
Greg

Tom
Wed Nov 19 20:28:10 CST 2003

How about just storing the session variable value, somewhere in the SQL
server?


"GJones" <support@snapanswers.com> wrote in message
news:070f01c3af00$178440f0$a301280a@phx.gbl...
> Is there away to capture a session variable value from IIS
> and use it in a SQL 2000 trigger with out passing it as a
> part of a string query. I just want to capture it somehow
> systemically.
>
> Thanks,
> Greg
>

Bob
Thu Nov 20 05:30:49 CST 2003

GJones wrote:
> Is there away to capture a session variable value from IIS
> and use it in a SQL 2000 trigger with out passing it as a
> part of a string query. I just want to capture it somehow
> systemically.
>
> Thanks,
> Greg

No, you will not be able to use a trigger for this. Instead, create a stored
procedure to which you pass the value as a parameter, and have the stored
procedure do the task that you are intending the trigger to do. You will
need to remove DELETE permissions on the table so all deletions will need to
be done via the stored procedure.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"