--- title: "Programming Specific Tasks | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql-server-2016" ms.reviewer: "" ms.suite: "" ms.technology: - "docset-sql-devref" ms.tgt_pltfrm: "" ms.topic: "reference" helpviewer_keywords: - "Visual Basic [SMO]" - "Visual C# [SMO]" - "programming [SMO]" - "SQL Server Management Objects, programming" - "SQL Server Management Objects, tasks" - "SMO [SQL Server], programming" - "SMO [SQL Server], tasks" ms.assetid: a15949ef-88d9-4205-892e-0b66588b4fcc caps.latest.revision: 32 author: "JennieHubbard" ms.author: "jhubbard" manager: "jhubbard" --- # 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](../../../relational-databases/server-management-objects-smo/tasks/using-linked-servers-in-smo.md)|Describes how SMO uses the object to link OLE-DB servers.| |[Configuring SQL Server in SMO](../../../relational-databases/server-management-objects-smo/tasks/configuring-sql-server-in-smo.md)|Describes how to view and modify configuration settings for the instance of [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] in SMO.| |[Using Table and Index Partitioning](../../../relational-databases/server-management-objects-smo/tasks/using-table-and-index-partitioning.md)|Describes how to use index and table partitioning in SMO.| |[Using Filegroups and Files to Store Data](../../../relational-databases/server-management-objects-smo/tasks/using-filegroups-and-files-to-store-data.md)|Describes how to use file groups in SMO.| |[Managing Services and Network Settings by Using WMI Provider](../../../relational-databases/server-management-objects-smo/tasks/managing-services-and-network-settings-by-using-wmi-provider.md)|Describes several ways to keep track of the instance of [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] by using the object that represents the WMI Provider for Configuration Management.| |[Working with Database Objects](../../../relational-databases/server-management-objects-smo/tasks/creating-altering-and-removing-database-objects.md)|Describes how to create instance classes that represent objects on the instance of [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)].| |[Managing Users, Roles, and Logins](../../../relational-databases/server-management-objects-smo/tasks/managing-users-roles-and-logins.md)|Describes how to use security roles in SMO.| |[Granting, Revoking, and Denying Permissions](../../../relational-databases/server-management-objects-smo/tasks/granting-revoking-and-denying-permissions.md)|Describes how to use the SMO to grant, revoke, and deny permissions to users or members of a role.| |[Using Encryption](../../../relational-databases/server-management-objects-smo/tasks/using-encryption.md)|Describes how to protect data using encryption in SMO.| |[Scheduling Automatic Administrative Tasks in SQL Server Agent](../../../relational-databases/server-management-objects-smo/tasks/scheduling-automatic-administrative-tasks-in-sql-server-agent.md)|Describes how to use the [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Agent to monitor, report, and schedule jobs in SMO.| |[Backing Up and Restoring Databases and Transaction Logs](../../../relational-databases/server-management-objects-smo/tasks/backing-up-and-restoring-databases-and-transaction-logs.md)|Describes how to back up and restore databases and transaction logs in SMO.| |[Scripting](../../../relational-databases/server-management-objects-smo/tasks/scripting.md)|Describes how to script objects and discover dependencies between objects in SMO.| |[Transferring Data](../../../relational-databases/server-management-objects-smo/tasks/transferring-data.md)|Describes how to transfer data in SMO.| |[Using Database Mail](../../../relational-databases/server-management-objects-smo/tasks/using-database-mail.md)|Describes how SMO makes use of e-mail services.| |[Managing Service Broker](../../../relational-databases/server-management-objects-smo/tasks/managing-service-broker.md)|Describes how to set up Service Broker using SMO.| |[Using XML Schemas](../../../relational-databases/server-management-objects-smo/tasks/using-xml-schemas.md)|Describes how to use the XML data type in SMO.| |[Using Synonyms](../../../relational-databases/server-management-objects-smo/tasks/using-synonyms.md)|Describes how to create synonyms in SMO.| |[Using Messages](../../../relational-databases/server-management-objects-smo/tasks/using-messages.md)|Describes how to use system messages, and how to define your own user-defined messages.| |[Implementing Full-Text Search](../../../relational-databases/server-management-objects-smo/tasks/implementing-full-text-search.md)|Describes how to implement full-text search catalogs and indexes in SMO.| |[Implementing Endpoints](../../../relational-databases/server-management-objects-smo/tasks/implementing-endpoints.md)|Describes how to create endpoints to handle payloads for Database Mirroring, SOAP requests, and Service Broker.| |[Creating and Updating Statistics](../../../relational-databases/server-management-objects-smo/tasks/creating-and-updating-statistics.md)|Describes how to set up and monitor statistics on a database in SMO.| |[Tracing and Replaying Events](../../../relational-databases/server-management-objects-smo/tasks/tracing-and-replaying-events.md)|Describes how to use the **Trace** and **Replay** objects in SMO to trace and replay events.|