Surface Area Configuration for Features (OLE Automation) - Database Engine
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 Microsoft SQL Server, these stored procedures are disabled by default.
Options
Enable OLE Automation
If checked, 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