The SYSTEM_USER function returns the Windows or SQL login name.
The USER function returns the current user's database user name.
6>
7> SELECT SYSTEM_USER -- Login
8> GO
------------------------------------------------------------------------------------------------------------------------
--------
BCE67B1242DE45A\Administrator
(1 rows affected)