PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
sp_xml_removedocument

B.
sp_xml_preparedocument

C.
sp_reserve_http_namespace

D.
sp_delete_http_namespace_reservation


Leave a Reply