Passing an ntext parameter to a Stored Procedure

[AppDev76]

Hi,
I have 2 sql server. A stored procedure on each. Stored procedure on server 1 needs to pass an ntext variable to sp on server 2 (this ntext parameter is basically an XML string).
The problem is that since I can't declare a local varaible as ntext inside a stored procedure, I can't pass it to the second server. If I use varchar (8000) it will cut some of my text. What is the best way to do this in SQL Server 2000?

Thanks

 

[mrdenny]

There really isn't a good way to do this. The best option that I've found for stuff like this is to create a holding table for the data, then have the second SQL server pull the data from that table.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[AppDev76]

Thanks for the fast reply!
We've decided to do the exact same thing (##global temp table)
I use SQL Server with ASP.NET and pass text fields with no problem, but I guess the temp table is better in this case.

Thanks