Exporting data to a XML file in SQL Server 2005

Exporting data to a XML file in SQL Server 2005 using a VB.NET stored procedure (now that SQL Server supports the new CLR integration). Must read!