Programming Specific Tasks

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

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.