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. |
Povratne informacije
https://aka.ms/ContentUserFeedback.
Kmalu na voljo: V letu 2024 bomo ukinili storitev Težave v storitvi GitHub kot mehanizem za povratne informacije za vsebino in jo zamenjali z novim sistemom za povratne informacije. Za več informacij si oglejte:Pošlji in prikaži povratne informacije za