Chapter 12. SQL Server Management Objects (SMO) Utility Classes
SMO utility classes
perform specific tasks and are work independently of the SQL Server instance. SMO utility classes can be grouped according to their function:
Backup and restore databases
Transfer schema and data between database instances
Trace and trace replay operations
Administering the Database Mail subsystem
The sections in this chapter describe these SMO utility classes and shows how to use them through programming examples.
There are three more SMO utility classes that are discussed in later chapters:
SMO classes used to administer SQL Server Agent are covered in Chapter 16.
SMO classes used to administer Service Broker are covered in Chapter 17.
SMO classes used to administer Notification Services are covered in Chapter 18.
The examples in this section are all built using Visual Studio 2005. The examples need a reference to the following assemblies:
Additional assembly references will be given for examples in which the assemblies are required.