Friday, December 12, 2008

sp_spaceused

sp_spaceused is a useful stored procedure for telling you how much physical space your database or database object consumes.

There are two obvious points with sp_spaceused.

It does not list the SQL2005 schema to which the object belongs
The data size values are text values to include the KB comment