April 20, 2006 at 9:27 pm
I have searched this site and done a Google search but without any results.
Short of writing my own extended SP (which I can do if I have to but it is not an elegant solution for this problem), is there a way to do this?
April 24, 2006 at 8:00 am
This was removed by the editor as SPAM
April 24, 2006 at 10:59 am
SQL Server 2000 was released in 2000 before the Web Services with all other .NET stuff was available around 2002.
As for Elegant Solution - you may upgrade to SQL Server 2005
Regards,Yelena Varsha
April 24, 2006 at 11:55 am
I use sp_OACreate to employ an email sending COM object. Perhps you could do the same to use serverXMLHTTP
[ http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290761 ]
In ASP I use this object to request data from simply web services. Not sure at all what the issues will be trying to use it from a sstored procedure or if it would work at all for that matter. Just an idea to look into.
Dave
Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply