How to consume a web service from within SQL Server using SQL CLR

Today I’ll show how you can consume a Web Service from within SQL Server using the SQL Server CLR.   DISCLAIMER: This is just intended as proof of concept. I do feel that if you wish to consume web services from SQL Server, then you should probably put this code in an assembly outside SQL…

6

Error : The OutputPath property is not set for project ‘xxxxx.dbproj’.

I had an interesting case the other day and I thought I’d share how we managed to get around the problem. This post will not discuss why this happens or if this is the correct behavior. It will just show a way to build your project.   So, the scenario is as follows. In Visual…

0