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.
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.
Describes how to script objects and discover dependencies between objects in SMO.
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.
Describes how to create synonyms in SMO.
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.
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.