Hugo Kornelis (10/27/2010)
USER_NAME() returns the name of the database user; SUSER_SNAME() returns the corresponding login.
Does SS manage to do that when the "client" is a webserver (IIS) which pools connections, especially ones which use one or a few trusted (database) logins?