Skip to content

Latest commit

 

History

History
31 lines (26 loc) · 2.82 KB

File metadata and controls

31 lines (26 loc) · 2.82 KB
title SQL Server Management Objects (SMO) Programming Guide
description SQL Server Management Objects (SMO) Programming Guide
author markingmyname
ms.author maghan
ms.date 03/14/2017
ms.service sql
ms.topic reference
ms.custom
ignite-2025
helpviewer_keywords
SMO [SQL Server]
SQL Server Management Objects
programming [SMO]
monikerRange =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

SQL Server Management Objects (SMO) Programming Guide

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Synapse Analytics FabricSQLDB]

[!INCLUDEssNoVersion] Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. [!INCLUDEssNoVersion] Replication Management Objects (RMO) is a collection of objects that encapsulates [!INCLUDEssNoVersion] replication management.

Topic Description
Getting Started in SMO Provides information on how to start developing a SMO application
Creating SMO Programs

Programming Specific Tasks
Provides information about programming the SMO objects in the Microsoft.SqlServer.management, Microsoft.SqlServer.Management.NotificationServices, Microsoft.SqlServer.Management.Smo, Microsoft.SqlServer.Management.Smo.Agent, Microsoft.SqlServer.Management.Smo.Broker, Microsoft.SqlServer.Management.Smo.Mail, Microsoft.SqlServer.Management.Smo.RegisteredServers, Microsoft.SqlServer.Management.Smo.Wmi, and Microsoft.SqlServer.Management.Trace namespaces.

This includes instructions to write programs that define databases and manage [!INCLUDEssNoVersion]. You can use SMO to create databases, perform backups, create jobs, configure [!INCLUDEssNoVersion], assign permissions, and to perform many other administrative tasks.
Replication Developer Documentation Provides information about programming the RMO objects in the Microsoft.SqlServer.Replication namespace.

See Also

Replication Developer Documentation