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 ...

Get Programming SQL Server 2005 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.