Get SQL Server Table Size

This is a very common problem to get space used by the Database objects. This stored procedure uses the sp_spaceused. This stored procedure has been tested and used on a SQL Server 2005 and it will work fine on SQL Server 2008 as well.