This documentation is archived and is not being maintained.

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.

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.