System Functions MSSQL Tutorial

EXEC sp_helpuser 'YourName'