What table replace Sysxlogins

• Kevin-130791

  SSChasing Mays

  Points: 622

  More actions

  September 6, 2007 at 1:55 pm

  #153806

  In SQL 2005 what table have replace sysxlogins in the previous version of SQL?  Is it sys.syslogins? I had a script which perform a function base on the column xstatus & srvid in sysxlogins But sys.syslogins doesn't have those columns unless status(sys.syslogins) is the same as xstatus(sysxlogins)

• noeld

  SSC Guru

  Points: 96590

  More actions

  September 6, 2007 at 2:32 pm

  #731966

  sysxlogins has always been undocumented. you get compatibility views only on on documented catalog tables ( and sometimes not even that).

  you should change your code to use "sys.server_principals"

  
  * Noel