MSSQLTips

http://www.mssqltips.com/tip.asp?tip=1172

Hi,

to explicit determine the guest user account I use your query as follow:

EXEC sp_MSforeachdb 'USE [?];
--IF THE DATABASE IS NOT A SYSTEM DATABASE
IF DB_ID(''?'') > 4
SELECT * FROM sys.sysusers WHERE name=''guest'';'
GO

Tosc,

Yes - You are correct.  We also have this tip related to sp_MSForEachDB:

http://www.mssqltips.com/tip.asp?tip=1414

Thank you,
The MSSQLTips.com Team