Is there a way I can save a XML Result Set to a file?

Question

So when I run my query which produces a XML file, is there any way to Save Results As... as a file? What should the Save as type be?

Thanks for your review and am hopeful for a reply

Answer 1

Hi,

Please check these links:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fa48ba92-a54c-4cac-9c6b-2b01d8ec9bc6/how-to-save-sql-query-result-in-an-xml-file-at-local-file-system?forum=sqlgetstarted

https://stackoverflow.com/questions/38808516/how-to-save-sql-query-result-to-xml-file-on-disk

Please mark this as answer if it solved your issue. 
Please vote this as helpful if it helps to solve your issue. 

Thanks,
Arulmouzhi

Answer 2

Hi ITBobbyP,

My understanding that you are in SSMS.

You need to click on the blue link in the SSMS Results pane, and select File => Save..

Please see below.

Answer 3

That Save as type is not in my drop down...but I can try saving as .xml

Answer 4

This did not work. When I open it in Notepad is one long line of text rather than appearing as true XML

Answer 5

Hi ITBobbyP,

• What is your SSMS version?
  I shared with you a screen shot of my SSMS, its version is 17.9.1

• Your XML file is not indented, which is ok. That's why it is a one line.
  To properly see an XML file, you can open it in any Internet browser.

Answer 6

Hi ITBobbyP,

Did you save in this way? 

or

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].