ROCNDAV
JahsonKim
/ enableOleAutomation.sql
Last active
May 17, 2023 12:56
How to send http POST request from sql server stored procedure. Important! For some reason sp_OAGetProperty is returning null. Am not sure why and if anyone has an idea can update the gists. In case you need to try another option SQL CLR would help. Check here https://gist.github.com/JahsonKim/05e6af7744f2d7ef814e5ed331419db5
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --This query enables ole automation procedures. set 0 to disable | |
| exec master.dbo.sp_configure 'Ole Automation Procedures', 1 | |
| RECONFIGURE | |
| --OLE utomation disabled the following error is thrown. | |
| --SQL Server blocked access to procedure 'sys.sp_OACreate' of component | |
| --'Ole Automation Procedures' because this component is turned off as part | |
| --of the security configuration for this server. | |
| --A system administrator can enable the use of 'Ole Automation Procedures' |