<div>
Thank you lsavidge and Richard Ding...worked perfectly!<br />
<br />
To future readers of this thread, the above delivers exactly what my question asked.
</div>


Thank you lsavidge and Richard Ding...worked perfectly!

To future readers of this thread, the above delivers exactly what my question asked.

<div>
It is a brilliant sp. Glad it helped you.
</div>


It is a brilliant sp. Glad it helped you.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am working on a SQL Server 2008 box.<br />
<br />
Using SYSOBJECTS or other system tables, I would like to identify the MB per table, does anyone know how to write a query that will return these results?<br />
<br />
Thanks
</div>
</div>


Hello,

I am working on a SQL Server 2008 box.

Using SYSOBJECTS or other system tables, I would like to identify the MB per table, does anyone know how to write a query that will return these results?

Thanks

In SQL Server 2008, how to identify MB per table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.