I found this query on Google Groups,
select sum(length) from syscolumns where id = object_id('Table Name')
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.