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

93 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    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
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base