I want to consume simple wsdl webservices using T-SQL stored procedure for more security. How to use it. is it possible?
Asked
Active
Viewed 564 times
0
-
How is consuming a webservice from a stored proc going to increase security? Your question doesn't make a lot of sense. – Sean Lange Feb 10 '15 at 16:24
-
Anyway but is it possible? – Prashant Patel Feb 10 '15 at 16:28
-
It is possible to call a webservice from a stored procedure but not at all advised. What have you tried? – Sean Lange Feb 10 '15 at 16:30
-
Try this link. There are plenty of example. https://www.google.com/search?q=sql+server+call+web+service – Sean Lange Feb 10 '15 at 16:31
-
[Here is my question](http://stackoverflow.com/questions/12913945/consuming-web-service-using-sql-clr-stored-procedure-not-find-default-endpoint-w) about a problem while implementing this solution - [read comments](http://stackoverflow.com/questions/12913945/consuming-web-service-using-sql-clr-stored-procedure-not-find-default-endpoint-w) to it which are mostly about why you shouldn't do this. – Serg Feb 12 '15 at 14:31