You don't necessary need a trigger for that. A SQL server has a built-in function that returns the identifier on the current connection:

SELECT suser_sname()

returns this identifier in the form:

You...