how to obtain a user name from sql server 2005 at run time

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

CrazyMan SSChampion Points: 12560 More actions · Answer 1

Enable triggers and use Host_Name () function if you are using a Domain login, or use trace to get the login, if this is what you are looking for

🙂

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

user_name() or suser_sname() might be what you want if you want the account making the change. Host_name is the computer name, if it's sent.

neneco56 Ten Centuries Points: 1232 More actions · Answer 3

Ten Centuries

Points: 1232

October 15, 2008 at 8:37 am

beautifull thank you !!!! works

thanks alot

CrazyMan SSChampion Points: 12560 More actions · Answer 4

Ops Steve, thats my mistake, that explains to it self that it is a computer name, 😀