Comment Updated

My original comment had said that the one exception to the "don't use the root" rule was the ephemeral D drive for Azure VMs.

However, having experimented, you shouldn't put...

• This reply was modified 1 year, 11 months ago by  JohnBevan. Reason: Original comment contained incorrect advice

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...