Apr 17, 2008

Expose Stored Procedure with SQL 2005

I needed to expose a SQL 2005 stored procedure as Web Service. I searched the net and found that it can be done straight forward by the SQL 2005 tools , the End Points.
It is very simple to do it follow this link

http://msdn2.microsoft.com/en-us/library/ms345123.aspx#sql2005websvc_topic4

really three steps and you done:
  1. Create the stored procedure.
  2. Create the End Point that exposes the stored procedure.
  3. Grant the user access to the end point.