Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine user & application in Trigger ?

Status
Not open for further replies.

power97

Programmer
Sep 17, 2003
67
CA
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

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top