BizTalk Database Login list

CREATE TAVKE # TEMPWW(
LoginName nvarchar(max),
DBname nvarchar(max)
Username nvarchar(max),
AliasName nvarchar(max)
)

INSERT INTO #TEMPWW
EXEC master..sp_msloginmappings


-- display results
SELECT * FROM #TEMPWW
ORDER BY dbname, username

--cleanup
DROP TABLE #TEMPWW


Or prepare list manually:


 

Logins

Server Roles

User Mapping

User Mapped to this login

Database role membership for: AIF Common

Y

Y