This is a SQL Server 2000 question yet will be used directly with Remedy. What I want to do is pass an XML document into a stored procedure. Before I use the XML I need to validate it. The built-in module sp_xml_preparedocument is supposed to perform this validation. However, if for any reason the document is not considered well formed the stored procedure aborts with no way of trapping the error.
In SQL Server 2000 extended procedures can be created using C++ but I do not yet program in this language. With SQL Server 2005 this is not an issue because I can write a .Net stored procedure and use TRY/CATCH. The only way I can see to accomplish this is to write a .Net .exe file and shell out. For performance reasons I would rather not have to run an executable from within a stored procedure. Does anyone have a solution for validating an XML document within a SQL 2000 stored procedure? Thanks. Stephen _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
