ole-automation-stored-procedures-transact-sql.md

title	OLE Automation Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/16/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	system stored procedures [SQL Server], OLE Automation OLE Automation [SQL Server], stored procedures
ms.assetid	ff16a833-01fe-4877-8aa6-55b72603ec2e
author	CarlRabeler
ms.author	carlrab

OLE Automation Stored Procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

[!INCLUDEssNoVersion] supports the following system stored procedures that allow OLE Automation objects to be used within a [!INCLUDEtsql] batch. By default, [!INCLUDEssNoVersion] 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