>>I figured it out. I was writing a few characters into every TEXT field instead of ''. The size dropped from 2.2 gigs to 40 megs. Whew!
>
>Hi Evan,
>
>In SQL 2005 it's better to use varchar(MAX) instead of text. If you have to use text, check http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/caveats-of-the-text-datatype.aspx

Thank you.