Programming Specific Tasks

Programming-specific tasks using SMO objects include complex subjects that would only be required by programs with a specific function, such as backing up, monitoring statistics, replication, managing instance objects, and setting configuration options.

Topic

Description

Using Linked Servers in SMO

Describes how SMO uses the LinkedServer object to link OLE-DB servers.

Configuring SQL Server in SMO

Describes how to view and modify configuration settings for the instance of SQL Server in SMO.

Using Table and Index Partitioning

Describes how to use index and table partitioning in SMO.

Using Filegroups and Files to Store Data

Describes how to use file groups in SMO.

Managing Services and Network Settings by Using WMI Provider

Describes several ways to keep track of the instance of SQL Server by using the ManagedComputer object that represents the WMI Provider for Configuration Management.

Working with Database Objects

Describes how to create instance classes that represent objects on the instance of SQL Server.

Managing Users, Roles, and Logins

Describes how to use security roles in SMO.

Granting, Revoking, and Denying Permissions

Describes how to use the SMO to grant, revoke, and deny permissions to users or members of a role.

Using Encryption

Describes how to protect data using encryption in SMO.

Scheduling Automatic Administrative Tasks in SQL Server Agent

Describes how to use the SQL Server Agent to monitor, report, and schedule jobs in SMO.

Backing Up and Restoring Databases and Transaction Logs

Describes how to back up and restore databases and transaction logs in SMO.

Scripting

Describes how to script objects and discover dependencies between objects in SMO.

Transferring Data

Describes how to transfer data in SMO.

Using Database Mail

Describes how SMO makes use of e-mail services.

Managing Service Broker

Describes how to set up Service Broker using SMO.

Using XML Schemas

Describes how to use the XML data type in SMO.

Using Synonyms

Describes how to create synonyms in SMO.

Using Messages

Describes how to use system messages, and how to define your own user-defined messages.

Implementing Full-Text Search

Describes how to implement full-text search catalogs and indexes in SMO.

Implementing Endpoints

Describes how to create endpoints to handle payloads for Database Mirroring, SOAP requests, and Service Broker.

Creating and Updating Statistics

Describes how to set up and monitor statistics on a database in SMO.

Tracing and Replaying Events

Describes how to use the Trace and Replay objects in SMO to trace and replay events.