sqlserver: find table names having more than X rows

find_tables_with_rows.sql

/* 
  Find all tables having more than X rows
  -----
  Prints table name if the table has more than @minRows rows
  Replace #{DBNAME} with database name
  Edit (or remove) where clause as desired
*/

select 'declare @name varchar(50), @ct int, @minRows int;
set @minRows = 0;'
union
select 'select @name = ''' + [name] + ''', @ct = count(*)
from ' + [name] + ' 
having count(*) > @minRows;

if @ct > 0 print @name;
set @ct = 0;
set @name = null;'
from #{DBNAME}.sys.tables t
where
	[name] like 'sb_tmp%'
	or [name] like 'sb2_tmp%'