Samples
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:
- On the Start menu, point to Programs/Microsoft SQL Server, and then click Configure SQL XML Support in IIS.
- Create a new virtual directory named "Demos" to access the Northwind database.
- Configure these three virtual names using a local path setting:
Name | Type |
---|---|
Dbobject | Dbobject |
T | Template |
S | Schema |
- On the Setting tab, check all the boxes.
- Save the configuration.
- In Control Panel, click Administrative Tools, and then click Internet Services Manager.
- 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.
- 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:
- Open SQL Query Analyzer.
- Connect to the Northwind database.
- Open the Mycustomers.sql.
- Execute the query.
- Open Mysproc.sql.
- Execute the query.
- Leave Query Manager running so you can run the OpenXML demos.
You can now run Url.htm.