sql server get user code example

Example 1: sql server get users

select * from master.sys.server_principals

Example 2: t SQl Checking Your Username

ORIGINAL_LOGIN(), CURRENT_USER
SYSTEM_USER;
SELECT ORIGINAL_LOGIN(), CURRENT_USER, SYSTEM_USER;

Example 3: sql get user account

SELECT CURRENT_USER;