OLE Automation Stored Procedures (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

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)

See Also

System Stored Procedures (Transact-SQL)
Ole Automation Procedures Server Configuration Option