Which TransactSQL statement should you use?

Your company uses an application that passes XML to the database server by using stored
procedures.
The database server has a large number of XML handles that are currently active. You determine
that the
XML is not being flushed from SQL Server memory.
You need to identify the system stored procedure to flush the XML from memory.
Which TransactSQL
statement should you use?

Your company uses an application that passes XML to the database server by using stored
procedures.
The database server has a large number of XML handles that are currently active. You determine
that the
XML is not being flushed from SQL Server memory.
You need to identify the system stored procedure to flush the XML from memory.
Which TransactSQL
statement should you use?

A.
sp_xml_removedocument

B.
sp_xml_preparedocument

C.
sp_reserve_http_namespace

D.
sp_delete_http_namespace_reservation



Leave a Reply 0

Your email address will not be published. Required fields are marked *