I'm not aware of anything which will tell you that such-and-such table takes xxx bytes. Closest thing I know is the DBCC command SHOWCONTIG, as:
Code:
DBCC SHOWCONTIG ('tablename')
While this command is used primarily to display information about the extent of a table or index's fragmenation, it does also display the number of pages allocated, the free space, etc.
Jeff Mason
Custom Apps, Inc.
www.custom-apps.com