Post reply

two entries of logins in sysxlogins but only one in syslogins

  • March 27, 2008 at 9:36 pm

    #71818

    hi all,

    we have a new SQL server hand over to us from outsource DBA team... here is the issue,

    When I execute this:

    SELECT name, password FROM syslogins

    WHERE name = 'sa'

    here is the result:

    name, password

    sa, **********

    (1 row(s) affected)

    but when this is executed,

    SELECT name, password FROM sysxlogins

    WHERE name = 'sa'

    name,password

    sa,*******

    sa,NULL

    (2 row(s) affected)

    distribution_admin is also duplicate.

    any one encounter this? I have no clue what happen..

    thanks in advance for assistance

    :-):cool:

  • March 28, 2008 at 1:23 pm

    #795436

    I believe that sysxlogins also stores remote logins for any linked servers set up on this particular instance in addition to the local logins.

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

  • March 31, 2008 at 1:49 am

    #795793

    hi,

    no linked server is setup in this instance.

    :-):cool:

  • March 31, 2008 at 7:40 am

    #795936

    sysxlogins is an undocumented system table in SQL 2000. I would be more concerned if syslogins had questionable data. Unless you feel your system is compromised I would not dedicate resources to looking into it further.

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

  • March 31, 2008 at 8:54 pm

    #796261

    thanks for the reply timothy... i am just wondering why because it is the first time I encountered this... is the replication might cause this? I am not familiar with replication though I have knowledge but i haven't dig more on it...

    btw... syslogins is a view referencing the sysxlogins...

    :-):cool:

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply