Building a SQLXML Web Service Application "  Chapter 7 305 optimize it, and finally return the result set. Ad hoc queries are statements sent to SQL Server that must be parsed and optimized before being delivered. By using stored procedures, you are subverting those steps, thus saving time and increasing performance and scalability. Creating a SQL Server Virtual Directory Somewhere you need to create the root folder for the virtual directory and the set of subfolders we will be using.You will need a folder named Track; inside of Track put the subfolder named SOAP.You can either establish the directory from C:\, or put the folder within the C:\inetpub\wwwroot folder next to your client application. Now that you have the database complete, you can create the vital piece to making this whole process work, the SQL Server Virtual root.Without this you will be unable to communicate to your SQL Server through HTTP. However, it is a simple process. First, either install or verify that the full install of SQLXML 3.0 from the Web Services Toolkit is ready to go.The Web Services Toolkit comes with the SQL 2000 Server. Once you have the Toolkit installed select the Configure IIS Support option from the submenu.You should be looking at the window shown in Figure 7.5. www.syngress.com Figure 7.5 IIS Virtual Directory Management for SQLXML 3.0 Window