| Using Linked Servers in SMO |
Describes how SMO uses the xref:Microsoft.SqlServer.Management.Smo.LinkedServer object to link OLE-DB servers. |
| Configuring SQL Server in SMO |
Describes how to view and modify configuration settings for the instance of [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] by using the xref:Microsoft.SqlServer.Management.Smo.Wmi.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 [!INCLUDEssNoVersion]. |
| 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 [!INCLUDEssNoVersion] 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. |