SQL Server - How to call url in sql server procedure?

Asked By madhavi N on 28-Mar-13 12:26 AM
Hi friends,

How to Call url in SqlServer Procedure?

Is it possible to call an URL from SQL Server Procedure?????

Thanks in advance
Robbe Morris replied to madhavi N on 28-Mar-13 08:35 AM
Several ways but you should not put logic like this in a stored procedure.  What specifically are you going to do with the response stream from the http request?  How do you intend to parse/read it?
madhavi N replied to Robbe Morris on 29-Mar-13 01:59 AM
Hi Morris,

I want to run one url on daily basis some particular time.So How can i schedule this url in SQL Server job?