• Very nice! Added to my utility "tool box."

    For Caruncles: If you have a situation where your db is running out of alloted space (such as on a 3rd-party shared server) you can use this script to see what objects are the space hogs. Often there are tables that can be "trimmed" of old data, or indexes rebuilt that will reduce the size of the db and avoid upgrade fees from the host.

    Or, in development, you can use this tool to see what your procedures are doing and confirm that they haven't created some endless loop that would cause a table to grow until it brings the server to its knees.

    Or, as I had to do just the other day, you need to analyze someone else's database and just want to see what's there. This tool will show almost instantly the most important tables because those would generally be the ones with high row counts. It will also tell you that certain tables are likely never used if the row count is zero.

    Just lots of good info about your db's tables and indexes.