David McKinney (7/9/2009)
It's early in the morning (pre-coffee) but where do you construct the xml?
XML is constructed in application framework. Our application architects made object's property as auditable and, if checked, XML constracted by application and passed as parameter to a stored procedure. It guaranteed that each XML is in required standard.