SQL and HTTP Request

  • Thread starter Thread starter Paul
  • Start date Start date
P

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?
 
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)
 
Back
Top