







SQL Server Setup Help | |
Surface Area Configuration for Features (OLE Automation) - Database Engine | |
![]() |
![]() ![]() |
Configuring a SQL Server Installation > SQL Server Surface Area Configuration > Surface Area Configuration for Features > |
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.