Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Correctly escape predefined entities in deadlock XML

If you create a table that has &, ", <, or > in the name, it's not correctly escaped in all instances of deadlock XML.

This causes an error when trying to convert extended event/system health data to valid XML for analysis.

https://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references

97 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Erik Darling shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base