Get Windows Account from SQL Login

From: Jeff M (anonymous_at_discussions.microsoft.com)
Date: 07/09/04


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

Hello,
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?

Thanks,
Jeff