Chapter 10. SQL Server Management Objects (SMO) Instance Classes, Part 1

SMO instance classes form a hierarchy matching the database server hierarchy. The top SMO objects are SQL Server instances represented by the Server object, under which is a hierarchy of instance objects that includes databases, tables, columns, indexes, and stored procedures.

This chapter provides an overview of the SMO instance classes for administering database objects that are used to store data. Following this overview, the chapter shows how to use these classes programmatically, how to subscribe to SMO events, and how to handle SMO exceptions. The chapter concludes with a reference to all SMO classes used to programmatically administer data storage objects . Chapter 11 covers SMO classes for administering database objects that are not used to store data.