Need to append to text variable

Question

Need to append to text variable

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

5409045121009-7368 SSCoach Points: 15740 More actions · Answer 1

I was thinking about getting away from the 8000 limit by not using XML. Suppose it will cause to much of a rewrite/mods?

ladonnas Mr or Mrs. 500 Points: 546 More actions · Answer 2

Yes, it would be a total rewrite to get away from XML because sproc b expects it in that format and does a lot of complex processing with it in that format.

I will look into the sp_OA methods. I haven't used them before. Thanks for pointing me in that direction as an alternative.