Server level Login variable for trigger?

Question

Post reply

Server level Login variable for trigger?

tripower

SSCrazy

Points: 2035
More actions
December 4, 2009 at 11:17 am

#156475

I have a trigger where I want to log the current Logged in user. Is there a server level variable that captures this info and if so what is it?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Let me refer you to Books On Line

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/e31254f1-6c41-4cbf-98b5-54daa7f81fd9.htm

and you can learn how to use the user's login name or user name.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

tripower SSCrazy Points: 2035 More actions · Answer 2

tripower

SSCrazy

Points: 2035

December 4, 2009 at 11:56 am

#1087941

That link is not an html link.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

Sorry about that link being faulty. Use books on line and search for:

CURRENT_USER (Transact-SQL)

Functions That Return User Names and User IDs

SESSION_USER (Transact-SQL)

USER (Transact-SQL)

USER_NAME (Transact-SQL)

Believe that one of these functions will return what you are looking for.

Again, sorry about that link being faulty.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

Try this one:

http://msdn.microsoft.com/en-us/library/ms191126.aspx

CEWII

Ron McCullough SSC Guru Points: 63877 More actions · Answer 5

Elliott W
Try this one:
http://msdn.microsoft.com/en-us/library/ms191126.aspx

The above link refers to SQL Server 2008 Books Online (October 2009)

and the user has posted his/her question to a SQL 2005 forum.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 6

suser_sname() - http://msdn.microsoft.com/en-us/library/ms174427%28SQL.90%29.aspx

user_name() - http://msdn.microsoft.com/en-us/library/ms188014%28SQL.90%29.aspx

There are related functions in those links as well. Pick the one that suits your needs.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 7

bitbucket-25253 (12/4/2009)
Elliott W
Try this one:
http://msdn.microsoft.com/en-us/library/ms191126.aspx
The above link refers to SQL Server 2008 Books Online (October 2009)
and the user has posted his/her question to a SQL 2005 forum.

True but the differences are pretty marginal for this...

CEWII