Get Windows Account from SQL Login

From: Jeff M (
Date: 07/09/04

Date: Fri, 9 Jul 2004 05:30:17 -0700

Does anyone know if there's a way to retrieve the Windows
account name from a connection established using an SQL
Server user account? I couldn't find any built-in
function such as USER_NAME or SYSTEM_USER that will do
this. Perhaps this is only possible if using Windows
Authentication to establish the connection. Any insight?