SQL Server/T-SQL Tutorial/System Functions/SYSTEM USER
Reporting Current User and Login Context
<source lang="sql">
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)</source>
select SYSTEM_USER
<source lang="sql">
10> SELECT CURRENT_TIMESTAMP, USER, SYSTEM_USER, CURRENT_USER, 11> SESSION_USER 12> GO
-------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------
----------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
2008-08-17 13:20:57.503 dbo J\Administrator
dbo dbo
(1 rows affected)</source>
Use SYSTEM_USER as a default value
<source lang="sql">
8> CREATE TABLE FunctionEx 9> (EntryDBUser varchar(128) DEFAULT SYSTEM_USER) 10> GO 1> 2> 3> drop table FunctionEx; 4> GO</source>