SQL Server 8 And SQL Server 2005 Management Tools In Consistencies

I have been investigating this issue and here is what I have found, when using SQL Server 8 Query Analyzer the results show that for example xp_regread has Execute permissions granted to €˜public€™ role. When checking the Same using the SQL Server 2005 Management Studio the results show that there are no Execute permissions granted to €˜Public€™ Role.



So the following Query doesn't return any results on Management Studio SQL Server 2005:

SELECT sysusers.name
, Status =
CASE protecttype

WHEN 204 THEN 'GRANT_W_GRANT'

WHEN 205 THEN 'GRANT'

WHEN 206 THEN 'REVOKE'

ELSE 'Unknown'

END

, Permission =

CASE action

WHEN 193 THEN 'SELECT'

WHEN 195 THEN 'INSERT'

WHEN 196 THEN 'DELETE'

WHEN 197 THEN 'UPDATE'

WHEN 26 THEN 'REFERENCE'

WHEN 224 THEN 'EXECUTE'

ELSE 'Unknown'

END

, sysobjects.name

FROM sysprotects, sysobjects, sysusers

WHERE sysobjects.id = sysprotects.id

AND sysprotects.action IN (193, 195, 196, 197, 224, 26)

AND sysprotects.uid = sysusers.uid

AND sysusers.name = 'public'

AND (sysobjects.name like '%xp_%' OR sysobjects.name like '%sp_OA%')



Where as running the Same Query in SQL Server 8.0 Query Analyzer will return results, saying there are a few extended procs available to Public for Execute.

Do you know whats going on here?

Thanks!