DECLARE @DB_Name VARCHAR(100)
DECLARE @Command nvarchar(200)
DECLARE database_cursor CURSOR FOR
SELECT name FROM master.dbo.sysdatabases WHERE name LIKE 'DB_Pattern%'

OPEN database_cursor

FETCH NEXT FROM database_cursor INTO @DB_Name

WHILE @@FETCH_STATUS = 0
BEGIN
     SET @Command  = N'SELECT COUNT(*) FROM ' + @DB_Name + '.dbo.TABLENAME'
     EXEC  sp_executesql @Command

     FETCH NEXT FROM database_cursor INTO @DB_Name
END

CLOSE database_cursor
DEALLOCATE database_cursor