MS SQL Server - OLE automation

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

OLE automation

00MichaelJordan

2006-12-06, 12:12 am

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

P. Ward

2006-12-06, 12:12 am

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.
>
>
>

Sponsored Links