Automating with ODSOLE
In the next few sections, we'll look at several examples that show how to automate COM objects using the sp_OA procs and ODSOLE. We'll walk through some basic examples that show how to access COM functionality that is probably already on your machine, then we'll explore automating SQL Server's Distributed Management Objects (SQL-DMO) from ODSOLE. We'll finish up with some esoteric coverage of implementing arrays in T-SQL using COM objects, using COM Interop and ODSOLE to access objects in the .NET Framework, and a few other odds and ends.
sp_checkspelling
Listing 15.1 illustrates a simple procedure that uses the sp_OA procedures to automate a COM object. The procedure instantiates the Microsoft Word Application object and ...
Get Guru's Guide to SQL Server Architecture and Internals, 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.
