From: Allan2010 on

Is there any replacement for SQLXML in sql server 2008 R2?

I have to produce XML export files based on my database data every night.
The XML structure has nested tags and is complex.

What would be the best tool to do this? I am aware of FORXML clause and I am
hoping to have a better option.

Thank you,