Programming Specific Tasks
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL database in Microsoft Fabric
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. |