SQL Server and COM Automation
SQL Server provides a set of stored procedures that allows you to automate COM objects from Transact-SQL. Automation is a language-independent method of controlling and using COM objects. Lots of applications expose functionality via COM objects. Many of Microsoft's retail products, as well as many from other vendors, expose some type of functionality via COM objects. You can use these objects to manipulate the host application through an automation controller—a facility that knows how to interact with COM interfaces. The most popular automation controller is Visual Basic, followed closely by VBScript. SQL Server's ODSOLE facility is an automation controller in its own right and is exposed via a set of system procedures ...
Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
