I want to be able to gather the information on a user to eventually write a stored procedure. So, I need to know how to get the information using T-SQL.

No, its not a Windows user. I removed the first line in the where clause but nothing was returned