Recently I was asked by one of my friend how to call a web service directly from a stored procedure.

He needs to track IP addresses using a stored procedures so, I suggested him two ways to call a web service using the SQL Procedure.Using SP_OACREATE with MSXML Create an assembly using SQL CLR using C#.

I personally tried using the first way to call a web service but was not successfulThen I learnt about SQL CLR programming with Visual Studio and C# and get it done in a first goAs a good friend I c...
Shout it
Telerik – OpenAccess ORM
.