Get Table Size in SQL Server 2008

To get table size in SQL server we need to write the query like as shown below

Example

SP_SPACEUSED 'USERDETAILS'

Once we run above query we will get output like as shown below