EXEC sp_MSforeachdb N'IF ''?'' LIKE ''DB_Pattern%''
BEGIN
 declare @DB_Name nvarchar(50)
 set @DB_Name = ''?''
 declare @Command nvarchar(MAX)
 set @Command  = N''SELECT COUNT(*) FROM '' + @DB_Name + ''.dbo.TABLENAME''
 EXEC  sp_executesql @Command
END';