Programming Specific Tasks

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.