Skip to Main Content
Programming SQL Server 2005
book

Programming SQL Server 2005

by Bill Hamilton
February 2006
Intermediate to advanced content levelIntermediate to advanced
586 pages
17h 35m
English
O'Reilly Media, Inc.
Content preview from Programming SQL Server 2005

Chapter 8. Native XML Web Services

SQL Server 2005 supports native XML web services for both SOAP 1.1 and SOAP 1.2 clients. The SQL Server Database Engine can be configured as an HTTP listener, allowing heterogeneous clients to access its data. You can send SOAP message requests to SQL Server over HTTP to execute T-SQL batch statements (with or without parameters), stored procedures, extended stored procedures, and scalar-valued user-defined functions (UDFs).

In SQL Server 2000, web service support is provided by SQLXML 3.0 and Internet Information Services (IIS), as well as the Microsoft Data Access Components (MDAC) stack installed on the client to access SQL Server. The inclusion of native web services in SQL Server 2005 allows a much wider group of clients to access the database, consistent with the platform and operating system interoperability goals for web services.

A client needs only HTTP and XML to access web services exposed by SQL Server 2005. This broadens access to SQL Server data across the extended enterprise from heterogeneous environments, including Unix and Linux systems and mobile devices. SQL Server 2005 includes built-in security measures to control client access.

Open Standards

SQL Server 2005 native XML web services are based on the following open standards :

Hypertext Transfer Protocol (HTTP)

A platform-independent protocol for exchanging data. HTTP is the underlying protocol for the Web. HTTP defines the format for messages, how they are transmitted, and ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

Leonard Lobel and Andrew Brust

Publisher Resources

ISBN: 0596004796Supplemental ContentErrata Page