SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Login ID - need some ideas
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

28 Posts

Posted - 10/16/2012 :  03:45:05  Show Profile  Reply with Quote

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?


Flowing Fount of Yak Knowledge

2240 Posts

Posted - 10/16/2012 :  03:53:25  Show Profile  Reply with Quote
To know the current windows login:

check this link

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000