Post reply

Syslogins - Wierd resultsets

  • November 3, 2006 at 9:19 am

    #91927

    All,

    I just ran 2 queries in syslogins on the same box and got different results!

    Query 1) select * from syslogins

    Query 2) select name, sysadmin from syslogins

    Query 2 is fine.  However, looking at Query 1, a lot of the members in the System Administrator role have a 0 in the sysadmin column, even tho they have 1 against them when I run the 2nd query!

    I run them both together so the result pane is split in two.

    Any thoughts on this?

  • November 6, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • November 9, 2006 at 2:20 pm

    #670938

    It seems no one knows. See my post, "How to get all accounts with sa privilege?" One way to get the same results may be to use text output rather than grid output.

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

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