SQL Server Table and Index Sizes
Created 06 May 2004 00:00
Use the following undocumented stored procedure to determine the number of rows in a table, and the amount of space used by the tables data and indexes:

sp_MStablespace 'object'