spAllTables

This script the full version of an example script for my article Is a Temporary Table Really Necessary? and will loop through all databases obtain the user tables in the database and perform an action on each of those tables (in this case sp_spaceused) without the use of a cursor or an undocumented

Read More - Register for Free Membership