sql solace: Enabling OLE Automation via TSQL

Tuesday, 27 January 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:

Subscribe to: Post Comments (Atom)