Who pulled the trigger? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Who pulled the trigger?

Author

Topic

pontifikas
Starting Member

32 Posts

Posted - 2004-09-01 : 03:23:50

I have an application which is used by varius users.Each user has a unique name(log in). The programm makes changes in the data base.
All changes fire the appropriate trigger(Ins,upd,del).
The trigger writes a row in a log Table containing varius data.

!I want one of the data to be the name of the user that made tha change!
How do I do this?

Thanks a lot.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-09-01 : 05:55:43

suser_sname() - look it up in BOL...