select count(*)
from sys.databases a inner join sys.syslogins b on a.owner_sid = b.sid
where b.[name] = 'PromisUser'
from sys.databases a inner join sys.syslogins b on a.owner_sid = b.sid
where b.[name] = 'PromisUser'
转载于:https://www.cnblogs.com/lfzwenzhu/archive/2011/04/08/2009054.html