Fascinating have I fallen into a alt.sports.boer newsgroup by mistake?

You'll need to do

Select * from (tablename) as ROOT for XML Auto, Elements

if you want <ROOT> around your output.