SQL Server Performance

How can we all logins details on 2000

Discussion in 'Getting Started' started by jagpalsingh4, Mar 13, 2008.

  1. jagpalsingh4 New Member

    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
  2. martins New Member

    As per my reply to one of your other posts, the structure is a bit different in SQL2K. There are no DMV's but you can still get all the information you want in the master database. Login info can be found in the master.dbo.sysxlogins table.
    Please refer to SQL2K Books Online for this kind of information, or just have a look in the master database of a SQL2K instance. You would find the answers you need a lot quicker by doing that...
  3. jagpalsingh4 New Member

    Hi,
    i have already done through this way anyway thaxx for reply me
    regards
    jagpal singh

Share This Page