Post reply

sysadmin

  • July 24, 2002 at 2:11 am

    #58478

    Hi,

    I run the folowing query :

    "select name,sysadmin FROM syslogins where sysadmin<>0"

    and here is resualt :

    Name SysAdmin

    NULL 1

    distributor_admin 1

    sa 1

    and i don't know what is "NULL"

    Any Ideas?

    SaNaZ

  • July 24, 2002 at 5:07 am

    #433280

    Is your server configured to allow updates to system catalogs (see allow updates option in BOL)? If so maybe somebody updated master.sysxlogins.name (the table on which the view syslogins is based) to be null for a login???

    Regards,

    Andy Jones

    .

  • July 24, 2002 at 6:01 am

    #433282

    Hi,

    Tanx for quick ur reply.

    It's "BUILTIN\Administrators".I find it with: select * from syslogins

    SaNaZ

  • July 24, 2002 at 6:01 am

    #433281

    Hi,

    Tanx for ur quick reply.

    It's "BUILTIN\Administrators".I find it with: select * from syslogins

    SaNaZ

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

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