Labels

How to enable Ole Automation Procedures in SQL Server?

Please execute below code on the server where you need to enable Ole Automation:


sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
Email Post
Labels:
Location: Greer, SC 29650, USA

Comments

Anonymous said…
thank you
September 18, 2012 at 8:04 AM
Matt Slocum said…
The "R" at the beginning of the second RECONFIGURE is missing. Otherwise it's an awesome script. Thank you!
November 16, 2012 at 8:17 AM
Matt Slocum said…
This comment has been removed by a blog administrator.
November 16, 2012 at 8:18 AM
UC said…
Thanks for your kind comment Matt. I corrected the typo now.
November 25, 2012 at 7:25 PM
Post a Comment