SQL Server: Sending HTTP Requests

8 July 2017

Here’s another fun trick I learned this week: sending HTTP requests with SQL Server. It turns out, we have access to a whole host of OLE automation classes from within SQL Server. The first thing we need to do is enable OLE automation. This is done with the sp_configure command.

Once OLE automation is enabled, you will be able to create OLE classes from within your scripts and stored procedures.