SQL and HTTP Request

Discussion in 'ASP .Net' started by Paul, Jun 13, 2008.

  1. Paul

    Paul Guest

    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?
    Paul, Jun 13, 2008
    #1
    1. Advertising

  2. Paul

    bruce barker Guest

    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?
    bruce barker, Jun 13, 2008
    #2
    1. Advertising

  3. Paul

    Munna Guest

    Munna, Jun 13, 2008
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian Birtle
    Replies:
    2
    Views:
    1,985
    John Saunders
    Oct 16, 2003
  2. Replies:
    6
    Views:
    4,773
    Tor Iver Wilhelmsen
    Aug 29, 2005
  3. James
    Replies:
    3
    Views:
    16,229
    Roedy Green
    Nov 25, 2005
  4. nRk
    Replies:
    1
    Views:
    974
    Steven D'Aprano
    Feb 12, 2009
  5. Gelonida N
    Replies:
    0
    Views:
    515
    Gelonida N
    Feb 27, 2012
Loading...

Share This Page