Sorry, I think I typed too many S's. Old habit from tracking machines too often.

suser_name() should return the security context.

http://msdn.microsoft.com/en-US/library/ms187934%28v=SQL.90%29.aspx