Ole Automation Procedures Option

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 Understanding Surface Area Configuration.

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