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

[code=sql]
select
sys.objects.[name],
sys.objects.[object_id],
count(sys.colum ns.[name]) As ColumnCount,
sum(sys.columns .max_length) As MaxLength
from
sys.objects
inner join sys.columns on sys.objects.obj ect_id = sys.columns.obj ect_id
where
sys.objects.[name] = Table_Name
group by
sys.objects.[name],
sys.objects.[object_id]
[/code]