O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required