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

Remote debugging of CLR Stored Procedures, two common errors and the reason behind them.

The Scenario: You are attempting to remotely debug a CLR stored procedure from Visual Studio 2008.   The Setup: Both debugger (VS 2008) and debugger target (Sql Server) is in the same domain but on different machines, which is a given, otherwise it would be hard to call it remote debugging.   An example on…

2