Determine user & application in Trigger ?

[power97]

Hi,
I have a trigger that I would like to insert a record into a table showing what column was updated , who did it , when and what application. I believe I can find out the user by using "suser_name()" but I would like to be able to get the application if possible.

Thanks
Jason

http://www.musicianwanted.ca

 

[nikhilparchure]

As far SQL Server goes
The system table sysprocesses has the above related information.

Currently I do not have (ASE) to check this out.
But the above information could be of your help.


Regards
Parchure Nikhil