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'