Find Guest user access level in all databases

EXAMPLE: 1
EXEC sp_MSforeachdb 'USE [?];
SELECT ''?'' as dbname,name,hasdbaccess FROM sysusers where name like ''guest'' ;'

EXAMPLE: 2
Declare @holdname sysname
Declare getdbname cursor for
Select name from master.sys.databases order by name
Open getdbname
fetch next from getdbname into @holdname
while @@fetch_status=0
BEGIN
    select @holdname,name,hasdbaccess from sysusers where name like 'guest%'
fetch next from getdbname into @holdname
END
close getdbname
deallocate getdbname

--To remove GUEST Access to the Database:
REVOKE CONNECT FROM GUEST 

EXAMPLE: 3
Declare @holdname sysname
Declare getdbname cursor for
Select name from master.sys.databases order by name
Open getdbname
fetch next from getdbname into @holdname
while @@fetch_status=0
BEGIN

--use this to revoke permissions in all databases at once.
REVOKE CONNECT from GUEST
--    use this to list down all the REVOKE sentences across Databases
select 'USE ' +@holdname+'; REVOKE CONNECT FROM '+name from sysusers where name like 'guest%'

fetch next from getdbname into @holdname
END
close getdbname
deallocate getdbname

--Another approach : 
EXEC sp_MSforeachdb 'USE [?]; REVOKE CONNECT FROM GUEST;'