The surest way to corrupt a youth is to instruct him to hold in higher esteem those who think alike than those who think differently.
 Nietzsche, Friedrich. “The Dawn.” In The Portable Nietzsche, ed. Walter Kaufmann. New York: The Viking Press, 1954, p. 91.
In this chapter, we'll talk about automating (i.e., controlling) COM components using SQL Server's Open Data Services Object Linking and Embedding (ODSOLE) facility. ODSOLE is implemented via Transact-SQL's sp_OA extended procedures (e.g., sp_OACreate, sp_OAMethod, and so on). We'll talk about how Automation works in general, then we'll explore several examples of it using the sp_OA procs.
This chapter updates my coverage of Automation via Transact-SQL ...