Sql-server – Size of a single Record ? SQL

sql serversql-server-2005

I have a scenario where every user has been allocated 2 MB of database space.
Now I have to show Percenatge usage of their allocated space, to do so I need to know the size of single record in the Table.

I have tried to use sp_spaceused and even wrote a custom procedure making use of datalength .. but they show vast difference in their result.

Is there any way around to get this thing right.

Best Answer

Run DBCC SHOWCONTIG with your table name

dbcc showcontig ('TableName') with tableresults

then look at max min and average record size