How to get Size of table in Sql Server?

Introduction: 

We can find Table size in sql server. Using sql query it is very simple to find out the size of the. In built stored procedures is there to find out the size of table i.e. “SP_SPACEUSED”
In this I will explain how to get table size in SQL server or query to get table size in SQL server 2008.

Following query is used to find out the size of table:

SP_SPACEUSED 'YOUR TABLE NAME'

Example: to fins the size of table “USERDETAILS”

SP_SPACEUSED 'USERDETAILS'

Result: