way to show user name when they are sysadmin

Is it possible to show the user name (such as 'phuser') who is a member of the sysadmin group (NOT my idea!) I notice if you go to current connections is SQL EM the name shows, but if I login as that user if I try, user, user_name, etc inside of QA it shows DBO

Do you mean current activity?

You can get similar information in Query Analyzer by running sp_who2

You can try this

IS_SRVROLEMEMBER ( 'sysadmin' [ , 'login' ] )

select name,* from master..syslogins where sysadmin = 1

I appreciate the help, what I need to actually do is create a trigger which will not allow this user to insert a record into a table. I tried to use a deny against that user , but sinde they are sysadmins they still can. i was going to try to write a trigger which identifies this specific user to roll back the insert