SQL Server getting the row size

SQL Server getting the row size

 

  

Greetings,

I have SQL Server 7 running in Windows 2000 O/S. I have a table in my
database with a field data type text. There are 2500 records are there. I
want to know the size of each rows with its size by descending or acending
order. I know can find out the table space by using sp_spaceuse, but no idea
how to find out the row sizes of a table.

Your help is really appriciated.

Thanks
Indu Nayak
MS Sql Server LazyDBA home page