April 3, 2006 at 9:45 am
we have a a stored proc that rolls through a table and processes rows. we write the status of the processing back to the table. this stored proc uses sp_xml_preparedocument. when preparedocument fails, it halts execution of the procedure thus not allowing us to write out the code that it failed. does anyone know how to trap an error off sp_xml_preparedocument and possibly continue execution of the procedure that is calling it?
April 3, 2006 at 10:56 am
This is an extended stored proc, so the errors reported and passed are out of our hands.....
There is possibility using the new try catch in SQL 2005......what db server are you working with?
April 3, 2006 at 11:39 am
we are on 2000, but we are planning on going to 2005, and I know they have much better support for XML anyway, plus the try / catch functionality. I guess it may have to wait until we upgrade.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply