COM and SQL Server

COM is evident in several places within SQL Server. To begin with, if you access SQL Server via ADO or OLE DB, you're doing so using COM—both ADO and OLE DB consist of collections of COM objects and interfaces. If you use Enterprise Manager, you're also using COM. As Chapter 15 demonstrates, Enterprise Manager is built on a collection of COM objects known as SQL-DMO. When you execute a linked server query, you're doing so via COM—OLE DB providers, as I've said, are COM components. When you call certain Transact-SQL commands, you're working with COM. For example, the BULK INSERT command is based on a COM object that loaded and accessed within the server.

When you use DTS or the ActiveX replication objects, you are again making ...

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.