SQL and HTTP Request
 

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?

RE: SQL and HTTP Request
 

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)


"Paul" wrote:

> 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?

Re: SQL and HTTP Request
 

On Jun 13, 8:57 pm, Paul <P...@discussions.microsoft.com> wrote:
> 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/200...-server-via-c/

best of luck

Munna