Determine Table Size
14-Jul-0909 Leave a comment
EXECUTE sys.sp_spaceUsed ‘dbo.TableName’
To determine for more tables need to use a cursor. See below and other articles ( unchecked )http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx
Stephen Shakespeare 