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

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

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