Which Transact-SQL 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 Transact-SQL statement should you use?
A. sp_xml_preparedocument
B. sp_xml_removedocument
C. DBCC DROPCLEANBUFFERS
D. DBCC FREEPROCACHE

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.