Stored Proc & Web service

[vamsimohan21]

Is it possible to call a web service from Stored Procedure (Sql Server 2000), If so how can we achieve this?

Thanks In Advance

[Wendelius]

vamsimohan21 wrote:

Is it possible to call a web service from Stored Procedure (Sql Server 2000)

One way could be to create a program that calls the web service and use for example xp_cmdshell to call this program.

The need to optimize rises from a bad design.My articles[^]

[Vimalsoft Pty Ltd]

Its not a Good idea. Why Dont you call a Stored a Stored Procedure from a Web Service?

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswam@its.co.za

[Dave Kreskowiak]

Mika Wendelius wrote:

xp_cmdshell

Not recommended because this opens a high-risk security hole. IMHO, xp_cmdshell should be avoided at all costs.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008

[Wendelius]

Dave Kreskowiak wrote:

Not recommended because this opens a high-risk security hole

True in many cases, but with Sql Server 2000 that was the only way that came in mind.

The need to optimize rises from a bad design.My articles[^]