How To Know The Size Used By A Record In A Table

Hi,

I need a query to know (calculate) the size used by a record in a field by table, I was tried with the follow query (but this only show me the max length of the data type):

SELECT c.name AS column_name
,c.column_id
,t.name AS type_name
,c.max_length
,c.precision
,c.scale
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
WHERE c.object_id = OBJECT_ID('dbo.bloqueos_2005')
ORDER BY c.column_id;
GO

I was tried whit the system views that contains column info, but no one give me the correct information.

If any one have the query or know some way to do this, please help me.

Thanks,

Diego Jaramillo Celis