Good day!
Sorry to trouble you.
Excuse me for my bad English .

I test XML support for SQL Server 2000.
I have already done some routine:
1. I make virtual directories:
- SQL2000 is type dbobject
- Templates is type template.
2. Allow Settings:
- URL Queries (yes)
- Template Queryes (yes)
- XPath (yes)
3. I run query: http://localhost/SQL2000/SQL2000?sql=select+*+from+MyTable+FOR+XML+AUTO&root=ROOT
4. All OK!!

5. I have written SQL template and saved him to the file (List1.xml)
6. I moved this file in folder "Templates"
7. I run query: http://localhost/SQL2000/Templates/List1.xml

I get error 500 in Internet Explorer Browser.

Content file List1.xml:

<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:query>
SELECT * FROM sysobjects FOR XML AUTO
</sql:query>
</ROOT>

Best Regards, Alexander Verezhynsky

P.S.
My configuration:
Windows 2000 enterprice edition.
MS SQLServer 2000.
Send request to Email: alex@asuaes.mk.ua for me,please!

Adding information:
I installing MS XML 3.0 (Replace MS XML 2.6 is default installing with Windows 2000).

My configuration:
Windows 2000 enterprice edition.
MS SQLServer 2000.

Send request to Email: alex@asuaes.mk.ua for me,please!