Export (0) Print
Expand All

OLE Automation Stored Procedures (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

SQL Server supports the following system stored procedures that allow OLE Automation objects to be used within a Transact-SQL batch. By default, SQL Server blocks access to OLE Automation stored procedures because this component is turned off as part of the security configuration for this server. A system administrator can enable access to OLE Automation procedures by using sp_configure. For more information, see Surface Area Configuration.

sp_OACreate

sp_OAMethod

sp_OADestroy

sp_OASetProperty

sp_OAGetErrorInfo

sp_OAStop

sp_OAGetProperty

Object Hierarchy Syntax (Transact-SQL)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft