Access NT / 2000 username in SQL SPs

• cpulford

  Newbie

  Points: 1

  More actions

  August 23, 2002 at 6:34 am

  #158083

  Hi

  I am using Windows Integrated authentication for my intranet web site and SQL server. Is there a way to extract the Windows username (rather than SQL server equivalent) of the user accessing the web site in a SP?

  Thanks

  Chris

• Antares686

  SSC Guru

  Points: 125444

  More actions

  August 23, 2002 at 7:16 am

  #435196

  Try SYSTEM_USER.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)