Calculate an Existing SQL Tables Max Row Size

I found this query on Google Groups,

select sum(length) from syscolumns where id = object_id('Table Name')
posted by Aaron Fischer on Monday, April 09, 2007 1:50:40 PM (Pacific Standard Time, UTC-08:00) Comments [0]
All comments require the approval of the site owner before being displayed.
Name
E-mail
(will show your gravatar icon)
Home page

Comment (Some html is allowed: a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):
Live Comment Preview