OLE Automation 預存程序 (Transact-SQL)OLE Automation Stored Procedures (Transact-SQL)

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

SQL ServerSQL Server 支援下列可以在 Transact-SQLTransact-SQL 批次中使用 OLE Automation 物件的系統預存程序。supports the following system stored procedures that allow OLE Automation objects to be used within a Transact-SQLTransact-SQL batch. 根據預設,SQL ServerSQL Server 會封鎖對 OLE Automation 預存程序的存取,因為在這部伺服器的安全性組態設定期間已關閉這個元件。By default, SQL ServerSQL Server blocks access to OLE Automation stored procedures because this component is turned off as part of the security configuration for this server. 系統管理員可以使用 sp_configure 來啟用對 OLE Automation 程序的存取。A system administrator can enable access to OLE Automation procedures by using sp_configure. 如需詳細資訊,請參閱< Surface Area Configuration>。For more information, see Surface Area Configuration.

sp_OACreatesp_OACreate sp_OAMethodsp_OAMethod
sp_OADestroysp_OADestroy sp_OASetPropertysp_OASetProperty
sp_OAGetErrorInfosp_OAGetErrorInfo sp_OAStopsp_OAStop
sp_OAGetPropertysp_OAGetProperty 物件階層語法 (Transact-SQL)Object Hierarchy Syntax (Transact-SQL)

另請參閱See Also

系統預存程序 (Transact-SQL) System Stored Procedures (Transact-SQL)
OLE Automation 程序伺服器組態選項Ole Automation Procedures Server Configuration Option