Microsoft SQL Server 2005 Native XML web service enables us to make SOAP requests to SQL Server 2005 over HTTP. You can executes

 

 1. SQL Batch statements
 2. Stored Procedures
 3. and scalar valued User defined functions

How does it work?

 

      

 

Simplely we create a HTTP End Point in SQL Server
And enable Enable Microsoft SQL Server 2005 Native XML Web Service Option

Stay tuned for How to details and samples