Wednesday, July 15, 2015

Enable OLE Automation in SQL Server

In order to enable OLE Automation, run the following SQL Commands.


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