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?

Regards,
Madhavi