Surface Area Configuration for Features (OLE Automation) - Database Engine
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
The OLE automation extended stored procedures allow Transact-SQL batches, stored procedures, and triggers to reference custom OLE Automation objects. Use this dialog to control whether any of the following OLE automation procedures below can be executed.
- sp_OACreate
- sp_OADestroy
- sp_OAGetErrorInfo
- sp_OAGetProperty
- sp_OAMethod
- sp_OASetProperty
- sp_OAStop
In new installations of SQL Server, these stored procedures are disabled by default.
Options
Enable OLE Automation
If selected, the OLE Automation stored procedures are enabled.For more information about OLE Automation, see OLE Automation Objects in Transact-SQL in SQL Server Books Online.
For more information about configuring SQL Server options, see sp_configure (Transact-SQL) in SQL Server Books Online.
See Also
Concepts
Surface Area Configuration for Features
Surface Area Configuration for Services and Connections