我想我知道了：
DECLARE @table TABLE ( SERVER VARCHAr(100), db_name VARCHAr(100), db_role VARCHAr(100), db_user VARCHAr(100) )INSERT INTO @tableEXEC sp_msforeachdb ' USE [?]; SELECt @@SERVERNAME SERVER, ''?'' db, rp.NAME AS database_role, mp.NAME AS database_user FROM sys.database_role_members drm INNER JOIN sys.database_principals rp ON drm.role_principal_id = rp.principal_id INNER JOIN sys.database_principals mp ON drm.member_principal_id = mp.principal_id ORDER BY 3'SELECt SERVER, db_role, db_user, db_nameFROM @tableWHERe db_name NOT IN ( 'master', 'tempdb', 'model', 'msdb', 'DBA_UTIL' )ORDER BY 4 DESC, 2
