Thanks - managed to use this:

Select *

From dbo.Database_User_Profiles

For XML AUTO

and it worked fine.

Question is, where does the file end up on the server? I ran a search but cannot find...