About row size or length in mb or kb of a table

[bhmadhukar]

i created a table 'test' and with one column named with
ename varchar(20). it has two rows. now what my question is how i can calculate the row size or length (in kb or mb). can anyone tell me based on this example?

[ck9663]

i created a table 'test' and with one column named with
ename varchar(20). it has two rows. now what my question is how i can calculate the row size or length (in kb or mb). can anyone tell me based on this example?

try using this

-- CK

[deepuv04]

i created a table 'test' and with one column named with
ename varchar(20). it has two rows. now what my question is how i can calculate the row size or length (in kb or mb). can anyone tell me based on this example?

Hi,
you can also use the following query

select 
    sys.objects.[name], 
    sys.objects.[object_id], 
    count(sys.columns.[name]) As ColumnCount, 
    sum(sys.columns.max_length) As MaxLength
from 
    sys.objects 
    inner join sys.columns on sys.objects.object_id = sys.columns.object_id
where 
  sys.objects.[name] = Table_Name
group by 
    sys.objects.[name], 
    sys.objects.[object_id]