How can we all logins details on 2000

• jagpalsingh4

  Ten Centuries

  Points: 1311

  More actions

  March 13, 2008 at 10:46 am

  #184138

  Hi,

  I have this query according to my need and it works nicely in sql server 2005 .

  select name ,default_database_name from sys.server_principals

  Plz tell me appropriate query to see login detail in 2000 when i try to run this query this error comes

  Server: Msg 208, Level 16, State 1, Line 1

  Invalid object name 'sys.server_principals'.

  plz give me the write query

  thaxxxxx

  Jagpal Singh

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  March 13, 2008 at 11:08 am

  #789220

  Check out syslogins

  dab