SQL Server/T-SQL Tutorial/System Functions/sp helpuser

Reporting Database User Information

   <source lang="sql">

EXEC sp_helpuser "YourName"</source>