SQL Server/T-SQL Tutorial/System Settings/SUSER NAME

SUSER_NAME Function returns the name of the user logged into the server.

3>
4> select SUSER_NAME()
5> GO
--------------------------------------------------------------------------------------------------------------------------------
J\Administrator
(1 rows affected)
1>