Tuesday, January 27, 2009

Enabling OLE Automation via TSQL

How to enable OLE Automation via TSQL
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
GO
RECONFIGURE;
GO
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
I had to re-enable 'Agent XPs (hence that step above) as enabling OLE somehow disabled it :(

No comments: