TABLE 1: SQL Server's COM Automation Stored Procedures
Stored Procedure Description
sp_OACreate Creates an instance of an object in the context of the automation environment
sp_OADestroy Releases an instance of an object
sp_OAGetErrorInfo Obtains descriptive error information from the HRESULT error code that the other procedures return
sp_OAGetProperty Places an object property into a result set or local variable
sp_OASetProperty Changes the value of an object property
sp_OAMethod Executes an object method, sending parameters and getting a return value
sp_OAStop Shuts down the SQL Server automation environment