Returning XML from SQL Server

[wxdqz]

I have a web page that connects form controls to an XML DSO. The problem isthat when the table in SQL Server 2000 is empty (No Rows) then the storedprocedure that returns the XML doesn't return the structure of the table,thus the DSO fails. Everything works fine as long as there is data in thetable.How do I return the structure of the table in XML to the ASP page?This is the flow process.--SQL Server 2000 stored procedure (spGetTable1)-->COM+ object processes request and validates response-->ASP page uses the XML passed in from the COM objectI think I need to create an XSL schema but I'm not sure.If anyone could point me in the right direction with an example, book, website, etc. that would be greatly appreciated.Thanks in advance