Here's a version that'll run on one database and produce results for all databases (assuming they're setup as linked servers on the main db).

Could be further improved by putting the...

Heya,

possibly a bit late, but if it's still of use. . .

Alter procedure tabproc

(

@tablename sysname

)

as

begin

EXEC('Select count(*) from ' + @tablename + ' where isactive = 0' )

End

Basically the code in...