I need a Trigger which allows me to insert the name of the System user (not the db user) into my tables.

I tried it this way:
after insert
as
update THETABLE
set ERFDATE=getdate() ,
ERFNAME=SYSTEM_USER
where ID = (SELECT ID FROM INSERTED)

But the trigger inserts the name "DBO" in the Tables and not the system user name...