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