OLE Automation Stored Procedures (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2008) 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