Handles opened by sp_xml_preparedocument

Returns information about active handles that have been opened by sp_xml_preparedocument.


session_id | 0,
ID of the session. If session_id is specified, this function returns information about XML handles in the specified session. If 0 is specified, the function returns information about all XML handles for all sessions


The lifetime of sql_handles used to retrieve the SQL text that executed a call to sp_xml_preparedocument outlives the cached plan used to execute the query. If the query text is not available in the cache, the data cannot be retrieved using the information provided in the function result. This can occur if you are running many large batches.

Requires VIEW SERVER STATE permission on the server to see all sessions or session IDs that are not owned by the caller. A caller can always see the data for his or her own current session ID.


The following example selects all active handles.

select * from sys.dm_exec_xml_handles(0)


  1. Hey very cool website!! Guy .. Beautiful .. Wonderful .. I’ll bookmark
    your site and take the feeds additionally? I’m glad to seek out so
    many helpful information right here in the publish, we want
    work out extra strategies on this regard, thanks for sharing.

    . . . . .

    Feel free to visit my blog post … handmade earrings

  2. About the other hand, pipes give you a large selection of functional features, and lots of are works
    of art in addition to smoking implements.

    my webpage; head shops near me that sell kratom (Don)

  3. Please let me know if you’re looking for a writer for your blog.
    You have some really great posts and I think I would be a good asset.
    If you ever want to take some of the load off, I’d really
    like to write some material for your blog in exchange for a link back to mine.
    Please send me an email if interested. Many thanks!

  4. That is why they have a very exciting, dominations wikia so just give up
    their current jobs in a normal direction and so forth.
    We will write a simple idea but with the help
    of Android 2. Those pesky numbers just won’t line up evenly at
    the leisure time a new game play of digital devices, as well as docus about

  5. We should be cautious even though picking a locksmith, as we will need
    a skilled that will be ready to securely safe our treasured items.
    The very running property that is car or other vehicle is
    also locked to avoid its theft. Make sure you clean your
    face thoroughly before moisturizing.

    Feel free to surf to my website – סרטון

  6. Bramah manufactures locks for domestic and commercial use.
    It’s possible you’ll even search for evaluations online.
    A locksmith Apache service provider will be able to help you install a wide variety of locks and security devices
    that can improve the security of your house.

    Feel free to visit my web-site מעקות בהרצליה

  7. They can also provide you the total security systems
    installation for your residential or commercial purposes. • Don’t forget to check its compatibility with your building structure and the
    ability of the system to deliver a good sound quality which depends on the
    structure of your home. With a very good background to
    its credit, you will surely have a rewarding and ingenuous experience with a locksmith.

    My weblog … עבודות ברזל בראשון לציון

  8. Do you mind if I quote a couple of your articles as long
    as I provide credit and sources back to your website?
    My blog is in the very same area of interest as yours and my users would
    certainly benefit from some of the information you present here.

    Please let me know if this okay with you. Thanks a lot!

    my web page ניהול מוניטין

  9. I think this is one of the most vital information for me.
    And i’m glad reading your article. But should remark on some general
    things, The website style is ideal, the articles is really
    great : D. Good job, cheers

  10. A clever insight and fantastic suggestions you have on your site.

    You’ve got obviously spent a lot of time on this.

    Well done!

    Also visit my blog post male enhancer – Nelly

  11. Amazing! This can be one of the most beneficial blogs I have ever arrive across on this subject.

    In fact this is excellent. I’m also an experienced in this topic so I can understand your effort.

    Feel free to surf to my page volume plus

  12. Today, while I was at work, my sister stole my iphone and tested to see
    if it can survive a 40 foot drop, just so she can be a youtube sensation. My
    apple ipad is now destroyed and she has 83 views.
    I know this is totally off topic but I had to share it with someone!

    my web-site; goodnightjournal.com (Julio)

  13. Given here are six games that chicks would love you for playing:
    Scrabble – Scrabble is often a classic game which
    has been connected with nerds and geniuses. By doing this, you increased the memory of your Minecraft server
    from 100MB to 2GB which can be generally regarded as satisfactory to learn the overall game
    for some time. If you do not know how to experience the sport yet, there is absolutely no problem since its rules are easy to comprehend as well as the materials employed for the game is
    not hard to get or create.

Leave a Reply