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.

Options

Spot Price:

Option Type : Call Put
Strike price
Stock Purchase Price
Number Of Stocks
Stock Brokerage
Stock Cost
Price Per Share
Lot Size
Number of Lots
Option Purchase Price
Option Brokerage
Price Per Lot
Current value of stock/ index
Volatility % pa
Days left to expiration
Option Premium

Stock UGL
Options UGL
Net UGL