Post reply

Problem with Login info

  • October 2, 2005 at 11:06 pm

    #165791

    Hi all,

    In the syslogins table we have information about all the database logins .

    Now i am quering the user for auditing perpose.. In the column named isntname have values like this

    sntname

    1

    1

    1

    1

    1

    1

    Now when i execute this code

    SELECT name,isntname FROM master.dbo.syslogins WHERE isntname=0

    i get the result as

    name                          isntname

    bmssa                          0

    distributor_admin            0

    sa                                0

    Why it is showing records like this?

    Thanx

    from

    Killer

     

     

     

  • October 3, 2005 at 12:02 am

    #594491

    Hmm ... that would be because you're querying the syslogins view which is based on the sysxlogins table.

    The isntname column is derived from the xstatus column in sysxlogins using a bitwise operation.

     

    --------------------
    Colt 45 - the original point and click interface

  • October 3, 2005 at 1:32 am

    #594502

    Hi Phill,

     

    Thanx, I did not think on that point.

     

     

     

     

     

  • October 4, 2005 at 9:54 am

    #594909

    Here's an invaluable reference for the system tables (while they still exist):

    http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.mspx

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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