SQL Server 2005 Native XML Web Service

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

Comments

• Anonymous
  December 03, 2007
  I´d like to receive comments about everything that envolve C#, Web Service, SQl or XML. Thanks

• Anonymous
  November 21, 2008
  Is it possible to get the MOSS 2007 BDC to consume Http Sql Enpoints? Please reply to ericmckerrow@hotmail.com