current login

• Daniela-267581

  Ten Centuries

  Points: 1119

  More actions

  May 24, 2006 at 2:20 am

  #94247

  Hi,

  how coul I get the current login in a sql server express sesion?

  ---

  Daniela

• SQLZ

  SSChampion

  Points: 12872

  More actions

  May 24, 2006 at 3:48 am

  #639702

  select suser_sname(suser_sid())

  Think that should work in express.

  Karl
  source control for SQL Server

• Eric Peterson

  Hall of Fame

  Points: 3192

  More actions

  May 24, 2006 at 7:48 am

  #639770

  Here are some things that I track in a few triggers

   

  select

  getdate() , host_name(), @@serverName, current_user, system_user, @spid