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

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs
OLE Automation stored procedures (Transact-SQL)	OLE Automation stored procedures (Transact-SQL)	markingmyname	maghan	randolphwest	05/24/2023	sql	system-objects	reference	system stored procedures [SQL Server], OLE Automation OLE Automation [SQL Server], stored procedures	TSQL

OLE Automation stored procedures (Transact-SQL)

[!INCLUDE SQL Server]

[!INCLUDE ssNoVersion] supports the following system stored procedures that allow OLE Automation objects to be used within a [!INCLUDE tsql] batch. By default, [!INCLUDE ssNoVersion] 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_OADestroy
• sp_OAGetErrorInfo
• sp_OAGetProperty
• sp_OAMethod
• sp_OASetProperty
• sp_OAStop
• Object Hierarchy Syntax (Transact-SQL)

Note

Don't directly or indirectly call Automation procedures from any SQL Server common language runtime (CLR) objects. Doing so can cause SQL Server to crash unexpectedly. Additionally, an error message that resembles the following is logged in the application event log:

Information <Time stamp> Windows Error Reporting 1001 None
Fault bucket , type 0
Event Name: APPCRASH
Response: Not available
Cab Id: 0

Problem signature:
P1: sqlservr.exe
P2: 2009.100.4000.0
P3: 4fecc5ba
P4: StackHash_b620
P5: 6.1.7601.17725
P6: 4ec4aa8e
P7: c0000374
P8: 00000000000c40f2
P9:
P10:

Related content

• System stored procedures (Transact-SQL)
• Ole Automation Procedures Server Configuration Option