Ole Automation Procedures Server Configuration Option

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Use the Ole Automation Procedures option to specify whether OLE Automation objects can be instantiated within Transact-SQL 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 SQL Server.

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.

Examples

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  

See Also

sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)
Surface Area Configuration
Server Configuration Options (SQL Server)