SQL and HTTP Request

[Paul]

Does anyone know how I could run an HTTP request from within T-SQL?

Example: Requesting a .aspx page within a SQL Server 2005 database trigger?

 

[bruce barker]

I would call a webrequest from a trigger, it would keep the transaction open
too long. you should look at sqlservers service broker. in the trigger queue
a request to a service that does the web call. you can write this in the clr
language of your choice.

-- bruce (sqlwork.com)

 

[Munna]

Does anyone know how I could run an HTTP request from within T-SQL?

Example: Requesting a .aspx page within a SQL Server 2005 database trigger?

Hi

checkout this...

http://nicholasclarke.co.uk/blog/2008/01/16/web-request-from-sql-server-via-c/

best of luck

Munna