Posted by Plamen Ratchev on 05/10/07 12:41

"Jack Vamvas" <DEL_TO_REPLY@del.com> wrote in message
news:_sKdnZY6pNtPet_bnZ2dnUVZ8turnZ2d@bt.com...
>
> If you are using SQL 2000 and OPENXML , you will have problems. If this is
> the case , check
> http://www.quicksqlserver.com/2007/03/openxml_more_th.html
>

This is why I had to pass the XML content to the SP as NTEXT. That removes
the limitation of 8000 characters if trying to read the XML file directly
from SQL Server 2000. But the method in the link that you provided works
too, if direct read from a file is needed.

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]