Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Ole Automation Procedures in SQL 2005

Author  Topic 

manosgovind
Starting Member

12 Posts

Posted - 2013-01-04 : 00:11:59
Hi there,

I am New to sql server and I want to use the Ole Automation Procedures in sql server 2005.
When I run


sp_configure 'show advanced options', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

sp_configure 'Ole Automation Procedures', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

I get the following error:
The configuration option 'Ole Automation Procedures' does not exist, or it may be an advanced option.

I Can't find Ole Automation Procedures under Advanced Configurations.
And I have Enabled OLE Automation in SQL Server Surface Area configuration

Please Help me 2 solve this....

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-01-04 : 00:26:41
Check this link http://msdn.microsoft.com/en-us/library/ms191188(v=sql.105).aspx

--
Chandu
Go to Top of Page

manosgovind
Starting Member

12 Posts

Posted - 2013-01-04 : 00:46:12
Thanks for your Reply Chandu.

I've already tried that.
When I run that, I get the following error..

The configuration option 'Ole Automation Procedures' does not exist, or it may be an advanced option
Go to Top of Page
   

- Advertisement -