We help IT Professionals succeed at work.

Ole Automation Procedures in sql server 2012

205 Views
1 Endorsement
Last Modified: 2018-11-25
I need to call a rest api from my sql server, so I found a way of doing it but to make the code to run I need to enable
Ole Automation Procedures in sql server by running this query

sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
sp_configure 'Ole Automation Procedures', 1;  
GO  
RECONFIGURE;  
GO  

What I need to know is for sql server database security wise, is it good practise to call web api from a Stored procedure. As I am not a sql server dba or security expert.
I am open in there is any other way also.
Please let me know
Comment
Watch Question

Analyst Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION