neneco56
Ten Centuries
Points: 1232
More actions
October 15, 2008 at 8:03 am
#123941
I need to save the user at run time when it insert or update any field
How can I do that?
thanks
Nelsopn
CrazyMan
SSChampion
Points: 12560
October 15, 2008 at 8:07 am
#885230
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: 736068
October 15, 2008 at 8:14 am
#885239
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.
October 15, 2008 at 8:37 am
#885266
beautifull thank you !!!! works
thanks alot
October 15, 2008 at 10:26 am
#885345
Ops Steve, thats my mistake, that explains to it self that it is a computer name, 😀
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply