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.
| Author |
Topic |
|
tekguy
Starting Member
1 Post |
 Posted - 2009-08-31 : 11:00:18
|
| Hello,I am new to this forum. I recently started using SQL Server 2008 (I am a SQL 2000 developer). I was wondering if SQL Server 2008 has the ability to call web services?For example my goal is to poll a table in the database and if their are records I would like to call a web service and pass along the information in that table. Sure I can write a .NET service to read from the table and call the web service but I was wondering if I can write a complete application by just using the database. I tried searching but without much luck it seems like 2005 had the ability but now its depreciated? Any resources on this would be greatly appreciated.Thank you! |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-08-31 : 14:40:44
|
| Not sure about calling a web service, as its normally done over a .net application. Try using extended stored procedures, we havent used it to call XMLHTTP REQUEST and response object and am sure it can also be used for your purposesee alsohttp://blogs.msdn.com/sqlclr/archive/2005/07/25/Vineet.aspxhttp://www.eggheadcafe.com/articles/20040730.asphttp://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx |
 |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-08-31 : 23:25:54
|
| I'm pretty sure you can do it with SSISAn infinite universe is the ultimate cartesian product. |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-01 : 07:22:36
|
| Using CLR, you can have a stored procedure call a web service.And, as cat_jesus said, in SSIS use the "Web Service Task". |
|
|
|
|
|
|
SQL Server 2008 + Calling SOAP web service