I want to generate this in one query to keep a matrix of all our databases and having it in one query would make it easier to put into a...

Thanks! I also found a script that works. Its pretty cool and seems so simple. Here it is to check out.

SELECT    [name],sysadmin,bulkadmin,setupadmin,serveradmin,securityadmin,

processadmin,diskadmin,dbcreator

FROM         master..syslogins

where sysadmin =1 or bulkadmin =1 or setupadmin...