Programming SQL Server 2005

Chapter 11. SQL Server Management Objects (SMO) Instance Classes, Part 2

This chapter provides an overview of the SMO instance classes for administering database objects that do not store data. Following this overview, the chapter shows how to use these classes programmatically. Chapter 10 covers SMO classes for administering database objects that do store data.

Programming SMO Instance Classes for Administering Database Objects Not Used for Data Storage

The following SQL Server objects are considered not to store data. They identify the SMO instance classes that administer them.

Server configuration

Registered servers

Linked servers

Database defaults

Data files, log files, and filegroups

Partition functions and schemes

Logins

Users

Server, database, and application roles

Server and database permissions

.NET Framework assemblies

Endpoints

XML schemas

Languages

Statistics

Certificates

Credentials

Symmetric and asymmetric keys

Synonyms

System- and user-defined messages

Full-Text Search

OLE DB provider

A reference to the SMO classes that implement this functionality is included in the "SMO Instance Classes for Administering Objects Not Used for Data Storage Reference" section at the end of this chapter.

This section shows how to programmatically use SMO instance classes that are not used for data storage. The examples in this section are all built using Visual Studio 2005. You need a reference to the following assemblies to compile and run the examples:

• Microsoft.SqlServer.ConnectionInfo

• Microsoft.SqlServer.Smo ...