Posted - 10/16/2012 : 03:45:05
We have an application that manipulates data in SQL server
I have made some "audit" triggers that monitor what data is
being changed but I need to know WHO is changing it.
This application has a user login (user info and passw is stored id db)
which I somehow need to be able to access from within the database triggers.
(This login is not a sql srv. or windows login.)
Can I somehow set like a session variable with this user id which will
be only valid for the session I am working on?