334 Chapter 7 " Building a SQLXML Web Service Application Solutions Fast Track SQLXML Web Services SQLXML 3.0 is configured to work with .NET and will do the work of generating our WSDL file in order to process our stored procedures or User Defined Functions as Web Services. The main benefit is that it simplifies the interaction between SQL and multiple platforms and languages including various versions of Oledb (ADO), ODBC, JDBC,and so on; to better connect the Enterprise over an extranet, an intranet, or the Internet through the use of Active Server technologies (i.e., ASP, ASP.NET, JSP, PHP, etc.) and desktop or network applications built using various technologies (i.e., .NET,VB, C/C++, Java, etc.) on multiple platforms (Windows, UNIX, Linux, etc.). Using SQL Web Services is also a low-cost way to upgrade your current application to a .NET platform. Developing the TimeTrack Application If you choose, you may attach my database from the code section for Chapter 7 from the Solutions Web site (www.syngress.com/solutions).To attach a database to your sever, right-click on Databases in EM and select Attach Database. You want to use stored procedures because it is a huge performance gain over using ad hoc queries against the database. If you use stored procedures you will have precompiled and optimized results waiting for delivery as opposed to having SQL Server run through and parse the query and optimize it and then cache it and return the result set. Creating a SQL Server Virtual Directory SQLXML 3.0 enables you to be able to communicate to SQL Server via HTTP by creating a SQL Virtual Root Directory from one of your selected databases. With the virtual directory we can select the specific procs that we wish to use in our client application as Web Services. www.syngress.com