http from within stored procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

http from within stored procedure

Currently I’ve got a process where I do a save on a number of web pages , save the files to disk and then call the saved files from within a stored procedure and do various processes.
I would like to know if I can call thehttp:// file , i.ehttp://www.testsite.com/test.xml from within a stored procedure? Any advice would be useful ___________________________________
Advertise your IT vacancies for free at –http://www.ITjobfeed.com
http://msdn.microsoft.com/msdnmag/issues/03/10/XMLFiles/ see this for any help.l Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Thanks, that’s exactly what i was after ___________________________________
Advertise your IT vacancies for free at –http://www.ITjobfeed.com
Becareful when you are using the XML procedures…SQL server reserves the 1/8th memory of the total to this process…
Check Books Online… And also there is a menthod call nodes() method… http://msdn2.microsoft.com/en-us/library/ms345115.aspx
http://blogs.msdn.com/denisruc/
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>