| 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 |