openxml limitation

I am passing xmlstring as varchar(8000) to be used inside the openxml query.
At present I am using sql server 2000.
The issue is that some of the xmlstrings are longer than 8000 characters.
Tried using text but can not manipulate strings using text datatypes.

What is the alternative please?

You could upgrade to SQL Server 2005 to take advantage of the new VARCHAR(MAX) datatype.

Chris

|||

Any suggestions using sql server 2000?

Thanks