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. ...
Get Pro T-SQL 2008 Programmer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.