Unanswered: Possible bug? Query returns different results
If I run the following query I get a different value for isntgroup on different databases:
(select uid,name from sysusers where issqlrole = 1 and name != 'public') g left join
sysmembers m on g.uid = m.groupuid left join
sysusers u on u.uid = m.memberuid left join
master..syslogins l on u.sid = l.sid
order by 1, 2,3
i.e. I know that no one has db_accessadmin role, so I would expect a null value returned. Yet at times I get a 0. Status, which is used in the derivation of isntgroup, returns null. Is this a bug?