Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Call Web Service (.asmx page) from a Stored Proc

Author  Topic 

BigMeat
Yak Posting Veteran

56 Posts

Posted - 2012-06-17 : 07:04:33
Hi

I have a SQL 2008R2 Server and I want to call a web service from it. I know this is not great for performance. But it would be more efficient in the scenario m using it in. Is it possible? is it made easier in SQL Server 2012?

Many thanks in advance

Sachin.Nand

2937 Posts

Posted - 2012-06-17 : 07:30:25
You can write a CLR stored procedure to consume the web service.

Only free men can negotiate..
Go to Top of Page
   

- Advertisement -