>Are you sure you need your datatype to be "ntext"? It takes up a lot more space than "text". From BOL:

I couldn't quickly find a reference that indicated if Outlook msg.HTMLbody was Unicode or not, so I went with ntext just to be safe. Figured it would be easy enough to fix that later if it wasn't. Any idea if it can contain Unicode?

>Also, it appears that the ntext, text and image datatypes will go away in future versions of SQL Server (that was news to me, I guess I need to keep up with this stuff better). Again, from BOL:

Wow, thanks for the heads up. I'll have to check my SQL Server 2000 compatibility with those types and program accordingly. Thanks!