Calling COM From T-SQL
Calling COM From T-SQL Introduction If you need to store data or retrieve stored in SQL Server, no second thought is necessary and you will go for T-SQL. However, how can you integrate T-SQL with external applications? For example if you need to integrate SQL Server with Microsoft Exchange Server or MS Word, how are you going to accomplish this? There are seven extended stored procedures to call external applications like DLLs. Stored Procedure Description sp_OACreate Creates an instance of the OLE object on an instance of Microsoft SQL Server sp_OADestroy Destroys a created OLE object sp_OAGetErrorInfo Obtains OLE Automation error information sp_OAGetProperty Gets a property value of an OLE object. sp_OASetProperty Sets a property of an OLE object to a new value sp_OAMethod Calls a method of an OLE object sp_OAStop ...