Extended store procedure calling a webservice

• zoltan_ie

  Grasshopper

  Points: 14

  More actions

  April 11, 2003 at 8:01 am

  #80591

  Is it possible for an extended store procedure in SQL Server to call methods in .NET WebService?

  I know it is possible for extended store procedure to call methods that are in a DLL.

  I'm new to all this so if I don't make sense just say and I'll try and clarify.

  Tommy

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  April 11, 2003 at 10:25 am

  #453919

  Just a thought.

  You can use Sp_Oa ... methods for COM object access.

  So you can create MSXML.XMLHTTP object using sp_oaCreate and call the Open method with web serice url.

  The result will be in ResponseXml property of the same object.

  However note that this requires MSXML to be installed on the server.