SQL and HTTP Request

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • =?Utf-8?B?UGF1bA==?=
    #1

    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?
    Tags: None
    • =?Utf-8?B?YnJ1Y2UgYmFya2Vy?=
      #2
      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?

        Comment

        • Munna
          #3
          Re: SQL and HTTP Request

          On Jun 13, 8:57 pm, Paul <P...@discussio ns.microsoft.co mwrote:
          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

            Comment

            Previous template Next
            Working...