I'm in the process of converting a varchar(8000) field to an xml field in MSSQL 2005. Many of the XML docs have small issues (example: degree symbol not encoded). Is there a better way to validate the XML than a Try/Catch process?
Maybe I could write a .NET Stored Procedure. What is the proper method to validate (or invalidate) an XML document in .NET?