SQL Server Row Size - Stored Procedure ?

[rkershberg]

Is there a stored procedure or extended stored proc which returns the
table row size defined for a table ?

Thanks,

Rob

[Simon Hayes]

I'm not sure exactly what you mean - rows have a fixed maximum size of
8060 bytes. See "Estimating the Size of a Table" in Books Online, which
gives a formula for calculating the actual row size.

Simon

[rkershberg]

Simon:

What if you have a table and you need to increase the size of some of
your attributes, but you don't know the total size of the defined
fields you have already? I *HOPE* that MS doesnt require a calculator
and notepad to figure how the existing size of your defined fields in
your table ? Does this explain the issue better?

I appreciate your reply back.

Thanks,

Rob

[Simon Hayes]

OK, that's a bit clearer. To find the row size, ie. the sum of the
length of each data type, not the real length of the stored data, you
can do this:

select sum(length)
from syscolumns
where id = object_id('MyTable')

See syscolumns in Books Online for more details. If you want to see the
real length of the data, for example in a varchar column, then you can
use DATALENGTH().

Simon

[rkershberg]

May you have an exceptionally good weekend after this fine answer!

Makes sense that Microsoft would include this in a system stored proc
or extended stored proc ... doesnt it ???

Thanks VERY much (I *WILL* make a stored proc for this)

Rob