| title | Ole Automation Procedures Server Configuration Option | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2017 | |
| ms.prod | sql | |
| ms.prod_service | high-availability | |
| ms.reviewer | ||
| ms.technology | configuration | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | e8982e05-4984-4406-9760-285e8c028ddf | |
| author | MikeRayMSFT | |
| ms.author | mikeray |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
Use the Ole Automation Procedures option to specify whether OLE Automation objects can be instantiated within [!INCLUDEtsql] batches. This option can also be configured using the Policy-Based Management or the sp_configure stored procedure. For more information, see Surface Area Configuration.
The Ole Automation Procedures option can be set to the following values.
0
OLE Automation Procedures are disabled. Default for new instances of [!INCLUDEssNoVersion].
1
OLE Automation Procedures are enabled.
When OLE Automation Procedures are enabled, a call to sp_OACreate will start the OLE shared execution environment.
The current value of the Ole Automation Procedures option can be viewed and changed by using the sp_configure system stored procedure.
The following example shows how to view the current setting of OLE Automation procedures.
EXEC sp_configure 'Ole Automation Procedures';
GO
The following example shows how to enable OLE Automation procedures.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)
Surface Area Configuration
Server Configuration Options (SQL Server)