We need more information about who is updating or inserting new records in the database. I found some information about how to do the Date/Time part:
CREATE TRIGGER trg_updatedt ON [dbo].[tablename]
set modified = getdate()
where tablename.colid = inserted.colid
and I found code for the user:
But how do I fit in the Username in this trigger? I'm new to T-SQL.