SQL2000 sp3a
If I run the following query I get a different value for isntgroup on different databases:
select
g.name, u.name,l.loginname,u.isntgroup,u.status
from
(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?