check current user on mssql code example
Example 1: t SQl Checking Your Username
ORIGINAL_LOGIN(), CURRENT_USER
SYSTEM_USER;
SELECT ORIGINAL_LOGIN(), CURRENT_USER, SYSTEM_USER;
Example 2: sql get user account
SELECT CURRENT_USER;
ORIGINAL_LOGIN(), CURRENT_USER
SYSTEM_USER;
SELECT ORIGINAL_LOGIN(), CURRENT_USER, SYSTEM_USER;
SELECT CURRENT_USER;