Script Download: GuestUserCheck.ziphttp://gallery.technet.microsoft.com/scriptcenter/Guest-user-permission-ac9eecdb
Knowing about guest user in Sql server is a frequent security requirement. This can also be a source of confusion since many a times guest user is disabled in Sql Server msdb's Sql server and results in issues indicated in below mentioned KB.
Some forums for such requirements are below:http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/04940880-85c4-419a-a859-8a6bd58a18f0
Such a script should also help in below mentioned KB (KB has script for single database):http://support.microsoft.com/kb/2539091
You should not disable the guest user in the msdb database in SQL Server
Script does below:
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery