View Single Post
  #1 (permalink)  
Old August 2nd, 2005, 07:19 AM
mrookey mrookey is offline
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default UserId/Computer Name

Good morning! I am using DWMX with MS SQL and have created a history table that is populated via a trigger everytime an insert, update, or delete action takes place on a particular table. My problem is trying to capture either the UserId/Computer name of the person performing the action. I've tried "SUSER_SNAME" and "USER", but it only returns the Userid of the person currently logged on - me! Although I'm using session variables in the application, I can't seem to translate those into Userids in SQL - any ideas?