I am currently looking at using XML in one of the projects I am working on for my current client. My client uses SQL Server 7.0 and has no immediate plans to migrate to SQL Server 2000. The front-end of this project is written in ASP and uses ADO to connect to SQL. At the moment I am doing some proof of concept work, and my client seems happy with the results and wants to explore XML further. My proof of concept code involves writing stored procedures that build up strings containing XML, but this would not really be workable in the final solution. Are there any tools available that I can use which will help out here? Can I get something which will let SQL return valid XML, should I convert to XML in ASP or can I trick ADO into producing XML? I recall seeing some XML tools (possibly beta versions) released by Microsoft for SQL Server 7.0 but have had no luck tracking down any information on them recently. Does anyone have any information of ideas on how I can get (valid) XML out of SQL 7.0?