Capture SQL Logins

  • Wesley Brown

    SSChampion

    Points: 12045

    Comments posted to this topic are about the item Capture SQL Logins

    http://www.sqlserverio.com
    http://www.cactuss.org
    http://www.salssa.org

  • pankaj.baluni

    Ten Centuries

    Points: 1014

    Hello Wesley,

    I'm using SQL 2005 and didn't find ' master.dbo.sysxlogins'. please suggest how to go about it.

    in SQL 2000 we do see this table. Thanks in advance.

    Also, please share a modified query for SQL 2005 for this same purpose.

    Rgds,
    Pankaj

  • Silverfox

    SSC-Insane

    Points: 23150

    pankaj.baluni (10/5/2009)


    Hello Wesley,

    I'm using SQL 2005 and didn't find ' master.dbo.sysxlogins'. please suggest how to go about it.

    in SQL 2000 we do see this table. Thanks in advance.

    Also, please share a modified query for SQL 2005 for this same purpose.

    sysxlogins is sql 2000 only, try syslogins

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 3 posts - 1 through 3 (of 3 total)

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