Stored procedure to validate xml content against dtd I have a stored procedure which creates xml content and then is stored to a xml file. Is it possible to validate the generated xml content against a dtd file?

Thank you in advance!
It is not possible to validate XML against a DTD file using SQL Server.

You can validate the XML with a XSD stored in a XML Schema Collection using a strong typed XML variable 

DECLARE @x xml(YourXMLSchemaCollectionName);
SET @X = 'YourXML';