XMLDemo

This sample demonstrates Microsoft® SQL Server™ 2000 support for XML functionality.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Xml\XMLDemo

Running the Sample

To install virtual roots:

1. On the Start menu, point to Programs/Microsoft SQL Server, and then click Configure SQL XML Support in IIS.
   
   
2. Create a new virtual directory named "Demos" to access the Northwind database.
   
   
3. Configure these three virtual names using a local path setting:
   

Name	Type
Dbobject	Dbobject
T	Template
S	Schema

4. On the Setting tab, check all the boxes.
   
   
5. Save the configuration.
   
   
6. In Control Panel, click Administrative Tools, and then click Internet Services Manager.
   
   
7. Add a virtual root to the Web site name "Demodir", and configure it to refer to the same physical directory where you installed the demo files.
   
   
8. Save the configuration. Do not edit the "Demos" virtual directory entry. You should now have access to the files in the Northwind database.

To install the stored procedure and table:

1. Open SQL Query Analyzer.
   
   
2. Connect to the Northwind database.
   
   
3. Open the Mycustomers.sql.
   
   
4. Execute the query.
   
   
5. Open Mysproc.sql.
   
   
6. Execute the query.
   
   
7. Leave Query Manager running so you can run the OpenXML demos.

You can now run Url.htm.

See Also

XML Samples