Native XML Web Services Concepts
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Beginning with SQL Server 2005, SQL Server provides native XML Web Services through the SQL Server Database Engine by using the following open standards:
Hypertext Transfer Protocol (HTTP)
As the core protocol behind the World Wide Web, HTTP provides a platform-neutral Web-based exchange of data.
HTTP support requires the HTTP listener: Http.sys. Http.sys is available only on Windows Server 2003 and Windows XP Service Pack 2. For more information, see Configuring the HTTP Kernel-Mode Driver (Http.sys).
SOAP defines how to use XML and HTTP to access services, objects, and servers regardless of the operating system.
Web Services Definition Language (WSDL)
WSDL is an XML document format that can be used to describe Web-based services.
When you use Native XML Web Services in SQL Server 2005 or SQL Server 2008, you can send SOAP messaging requests to an instance of SQL Server over HTTP to run the following:
Transact-SQL batch statements, with or without parameters.
Stored procedures, extended stored procedures, and scalar-valued user-defined functions.