Hi Sushila,

suser_sname() prints the same user as user_name().

Here is my trigger:

CREATE TRIGGER [track_time] ON dbo.ATTENDEES

FOR UPDATE

AS

UPDATE ATTENDEES

SET timestamp1=GETDATE(), User_name1 =suser_sname()

FROM ATTENDEES

JOIN deleted ON ATTENDEES.FTKey=deleted.FTkey

AND ATTENDEES.Day1<>deleted.Day1