I found this query on Google Groups,
select sum(length) from syscolumns where id = object_id('Table Name')
Page rendered at Friday, November 21, 2008 4:18:23 AM (Pacific Standard Time, UTC-08:00)
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.