SQL Server's Object Model

To use SQL-DMO, you must understand the SQL Server object model. The object model is the hierarchy of exposed SQL Server objects you can use programmatically.

You follow the object model as you would a file directory tree. For example, the top level of the object model is the Application object.

NOTE

It is standard practice when creating OLE object models from a standalone application to include an Application object.

To use other objects, follow the tree to the next level to find the objects you will use, for example, the SQL Server object. Object models also contain objects that are dependent upon other objects. To use a dependent object, you must first have the parent object of the dependent object. For example, ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.