I am trying to save an XML data stream from an application to an SQL database. I have tried the data type of "text", however, it doesn't appear to save the entire document, only the first 250 characters.

Can someone provide some assistance and advice please?

Thanks in advance.