Checking for Well formedness of a XML before preparing the document in SQL Server 2000

To my knowledge to convert the XML into relational form, sp_xml_preparedocument is the only way. One problem with this stored procedures is, it always assumes a well formed XML. If the input to this proc is badly formed then it throws an error and Error handling block can't catch it.

Generation of Sample Execution Statement in SQL Server

Lot of times developers debug the application to find out what's going wrong on the database side.