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.



Programming SQL Server 2005
Programming SQL Server 2005
ISBN: 0596004796
EAN: 2147483647
Year: 2007
Pages: 147
Authors: Bill Hamilton

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net