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