Hi Tracy,

The BLOB and CLOB are not MS SQL Server data types. The Image, Text and Ntext are.


>You can create a BLOB or CLOB column and insert the whole xml to the column. Not the ideal way though I don't think. You might want to read this first for another option:
>
>http://www.samspublishing.com/articles/article.asp?p=99813&rl=1
>