How can I write the contents of an XML file (as text) to a SQL Server 7/2000 column (in a relevant table)? I have tried but only get the first 200 or so characters stored in the column. The column is of type Text (I&#039;ve also tried VarChar and NVarChar without success). I know how to do it programmatically using ASP and SQL, but it just won&#039;t store my XML correctly!<BR>Is it an XML thing or I am missing something really obvious...?<BR><BR>Any ideas?