Reporting Current User and Login Context : SYSTEM_USER « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. SYSTEM_USER

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)