Returns the user name for the specified user ID.
SUSER_NAME( [ user-id ] )
user-id The user ID of the user you are searching for.
LONG VARCHAR
If you do not specify user-id, the user name of the current user is returned.
SQL/2008 Transact-SQL extension.
The following statement returns the user name for a user with ID 101.
SELECT SUSER_NAME( 101 );