Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Login ID - need some ideas

Author  Topic 

GustiX
Starting Member

28 Posts

Posted - 2012-10-16 : 03:45:05
Hi,

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?

Ideas?

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-10-16 : 03:53:25
To know the current windows login:

check this link
http://blog.sqlauthority.com/2009/05/26/sql-server-find-hostname-and-current-logged-in-user-name/

--
Chandu
Go to Top of Page
   

- Advertisement -