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.

Using Linked Servers in SMODescribes how SMO uses the LinkedServer object to link OLE-DB servers.
Configuring SQL Server in SMODescribes how to view and modify configuration settings for the instance of SQL Server in SMO.
Using Table and Index PartitioningDescribes how to use index and table partitioning in SMO.
Using Filegroups and Files to Store DataDescribes how to use file groups in SMO.
Managing Services and Network Settings by Using WMI ProviderDescribes 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 ObjectsDescribes how to create instance classes that represent objects on the instance of SQL Server.
Managing Users, Roles, and LoginsDescribes how to use security roles in SMO.
Granting, Revoking, and Denying PermissionsDescribes how to use the SMO to grant, revoke, and deny permissions to users or members of a role.
Using EncryptionDescribes how to protect data using encryption in SMO.
Scheduling Automatic Administrative Tasks in SQL Server AgentDescribes how to use the SQL Server Agent to monitor, report, and schedule jobs in SMO.
Backing Up and Restoring Databases and Transaction LogsDescribes how to back up and restore databases and transaction logs in SMO.
ScriptingDescribes how to script objects and discover dependencies between objects in SMO.
Transferring DataDescribes how to transfer data in SMO.
Using Database MailDescribes how SMO makes use of e-mail services.
Managing Service BrokerDescribes how to set up Service Broker using SMO.
Using XML SchemasDescribes how to use the XML data type in SMO.
Using SynonymsDescribes how to create synonyms in SMO.
Using MessagesDescribes how to use system messages, and how to define your own user-defined messages.
Implementing Full-Text SearchDescribes how to implement full-text search catalogs and indexes in SMO.
Implementing EndpointsDescribes how to create endpoints to handle payloads for Database Mirroring, SOAP requests, and Service Broker.
Creating and Updating StatisticsDescribes how to set up and monitor statistics on a database in SMO.
Tracing and Replaying EventsDescribes how to use the Trace and Replay objects in SMO to trace and replay events.


Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
       Send    Add Content...  
Click to Rate and Give Feedback
Page view tracker