SELECT User_Name() derivation??

• Express12

  SSCoach

  Points: 18514

  More actions

  May 26, 2005 at 7:46 am

  #362739

  SELECT User_Name()

   

  always returns 'dbo' ... even though I am logged into enterprise manager as ABC_Web_User. Is this correct? Is there another function that I can use to get this?

  BT

• Express12

  SSCoach

  Points: 18514

  More actions

  May 26, 2005 at 7:52 am

  #561214

  select SUSER_SNAME()

  BT

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 26, 2005 at 8:33 am

  #561225

  Schizophrenic?

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Express12

  SSCoach

  Points: 18514

  More actions

  May 26, 2005 at 8:48 am

  #561235

  some says I am

      some says I ain't

          Jerry Garcia / Bob Weir!!! 

  BT