Database Engine Administration Programming

The Microsoft SQL Server 2005 Database Engine provides a number of administration APIs that can be used to create database and administration applications.

Database Engine Administration APIs

This section describes how to create database administration and management applications using the Database Engine administration APIs. The following table describes the topics in this section.

Topic Description

Database Engine Administration Programming Overview

Introduces the concepts for creating applications that manage or administer instances of the Database Engine.

SQL Server Management Objects (SMO)

SMO is a collection of objects that are designed for programming all aspects of managing instances of the Database Engine. SMO includes SQL Replication Management Objects (RMO), which is a collection of objects that encapsulates SQL Server replication management.

WMI and SQL Server

SQL Server supports the Windows Management Instrumentation (WMI) interface through a SQL Server WMI provider.

SQL Distributed Management Objects (SQL-DMO)

SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating the management of instances of the Database Engine and replication topologies.

See Also

Other Resources

Database Engine .NET Framework Programming
SQL Native Client Programming
SQLXML 4.0 Programming
Replication Programming

Help and Information

Getting SQL Server 2005 Assistance