how to find a current user name

[Milleniumlegend]

How to find the current user name for the database.

many thanks

 

[babeo]

[red]sp_who[/red] will indicate the process id, login name, host name, db name, and command executing, etc.

 

[JMCraig]

Depending upon what you want, this may do what you need more effectively:

select suser_name()

That will give you the login name of the user executing the code.

select user_name()

gives you the name-in-db of the user executing the code.

HTH,

John


J M Craig
Alpha-G Consulting, LLC

http://www.alphagconsulting.com

nsjmcraig@netscape.net