Forum Discussion

przemyslawswiesciak's avatar
przemyslawswiesciak
Copper Contributor
Sep 18, 2024

Typed XML validation via XSD - show all errors

Hi,

is there a way to show all existing errors when typed XML is validated?

 

I think MS SQL Server usues msxmlsql.dll to work with XML data.

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-xml-preparedocument-transact-sql?view=sql-server-ver16

 

https://learn.microsoft.com/en-us/sql/relational-databases/sqlxml/sqlxml-4-0-programming-concepts?view=sql-server-ver16

But I haven't found any information about this dll.

 

I'm wondering if there is an option in MS SQL Server like in:

https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ms767720(v=vs.85)

and

https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ms763769(v=vs.85) -> MultipleErrorMessages = true


Can you give me some advice?

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    There is no such option in SQL Server / Transact SQL available.