How to get current UserId within a SQL trigger? 1

[CathodeRay]

We are writing a trigger to track when changes are made to a particular table. Unfortunately, this particular table does not have a column like "MODIFIEDBY". Isn't there a global variable I can retrieve from within a SQL trigger?

 

[klewis10367]

This might help....

create trigger [trackEmployeeAdditions] on UPR00100
for insert
as
insert trackPayrollChanges
select system_user,'UPR00100','Inserted Record',getdate(),'Inserted Record','Inserted Record',EMPLOYID,
'Employee '+rtrim(EMPLOYID)+' was added' from inserted

 

[CathodeRay]

Got it... that "system_user" was what we were looking for. Thanks!