Post reply

sysxlogin vs. syslogin

  • July 9, 2010 at 3:02 am

    #75572

    Hi All,

    I have one question like what is the difference between sysxlogin and syslogin in sqlserver?

    I would really appreciated, help's me.

    Thanks & Regards

    Balaji.G

  • July 9, 2010 at 8:45 am

    #1190837

    Hi

    sysxlogins is a table, and syslogins is a view, which, looking at the definition, does a few things like convert the database id to a database name. It also converts the bitmask column containing the status value to 13 separate columns containing flags for things like whether a login is sysadmin etc.

    I'd say you would normally use syslogins rather than sysxlogins for querying.

    syslogins

    Duncan

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

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