How to create an OLE Automation object (Transact-SQL)

To create an OLE Automation object

  1. Call sp_OACreate to create the object.
  2. Use the object.
  3. Call sp_OADestroy to destroy the object.

Note All of these steps must be performed within a single Transact-SQL statement batch. All created OLE objects are destroyed automatically at the end of each statement batch.


See Also

System Stored Procedures

Data Type Conversions Using OLE Automation Stored Procedures

How to debug a custom OLE Automation server (Transact-SQL)

OLE Automation Sample Script

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.