Saturday, February 25, 2012

OLE automation

How do I start OLE automation in SQL 2005? Thanks.
You can enable OLE automation using the SQL Server Surface Area Configuration
Tool. To access the SQL Server Surface Area Configuration Tool select START
| Programs | Microsoft SQL Server 2005 | Configuration Tools | Surface Area
Configuration.
Select Surface Area Configuration for features and Select OLE Automation and
check Enable Ole Automation.
This can also be done programatically using the following script:
EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH
OVERRIDE
EXEC sys.sp_configure N'Ole Automation Procedures', N'1'
EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH
OVERRIDE
HTH
- Peter Ward
WARDY IT Solutiuons
"00MichaelJordan" wrote:

> How do I start OLE automation in SQL 2005? Thanks.
>
>

No comments:

Post a Comment