Consulta de tablas pobladas

[flaviovich]

Bueno, se me ocurrio esto sin pensar mucho:

Código:

declare @tabla varchar(255)
declare @qry varchar(100)

declare cr_mistablas cursor for
    select name from sysobjects where xtype='u'
for read only

open cr_mistablas
fetch next from cr_mistablas into @tabla

while @@fetch_status = 0
begin
    set @qry = 'select count(1) from ' + @tabla
    exec(@qry)
    fetch next from cr_mistablas into @tabla
end

close cr_mistablas
deallocate cr_mistablas

Creo que tu podras mejorar este script.