O'Reilly logo

Pro T-SQL 2008 Programmer's Guide by Michael Coles

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16. Data Services

Back in the days of SQL Server 2000 Simple Object Access Protocol (SOAP), web service support was provided primarily through SQLXML. The SQL Server 2000 model relied on a loose coupling of SQL Server and Internet Information Services (IIS), making setup and configuration a bit of a hassle. The end result was that a lot of developers found that creating web services in the middle tier was a far more flexible and easier-to-use solution than the SQL Server 2000/SQLXML/IIS model.

SQL Server 2005 introduced native HTTP endpoints to expose SPs and UDFs as web methods directly from SQL Server, via SOAP. HTTP endpoints were easy to create and administer, and the SQL Server HTTP endpoints model used SQL Server to provide security. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required