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
- Create the stored procedure.
- Create the End Point that exposes the stored procedure.
- Grant the user access to the end point.