Skip to content

Latest commit

 

History

History
39 lines (30 loc) · 2.29 KB

File metadata and controls

39 lines (30 loc) · 2.29 KB
title Getting Started in SMO | Microsoft Docs
ms.custom
ms.date 08/06/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology
ms.topic conceptual
helpviewer_keywords
SQL Server Management Objects, about SQL Server Management Objects
SMO [SQL Server], about SQL Server Management Objects
ms.assetid ecc62702-c0d5-4180-b3c2-16ec5030caa7
author markingmyname
ms.author maghan
monikerRange =azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Getting Started in SMO

[!INCLUDEappliesto-ss-asdb-asdw-xxx-md]

This page provides links to topics designed to help you get started using SQL Server Management Objects (SMO). The topics listed cover the SMO object hierarchy, writing programs in SMO, SMO and different programming languages, and specific programming tasks.

Installing SMO

Installing SMO gives instructions for installing and referencing the SMO assemblies.

Object Model

Object Model describes the SMO object hierarchy and how the objects relate to one another.

Programming Languages

Programming Languages describes the programming environment and includes detailed procedures to start writing an SMO program in C#.

General Programming in SMO

General Programming in SMO is an introduction to programming with SMO. This topic describes how to connect to an instance of SQL Server, and how to use properties, methods, and collections. More advanced topics describe data types, transactions, setting the capture mode, and event and exception handling.

Programming Specific Tasks

Programming Specific Tasks includes concepts and procedures about how to program specific tasks using SMO. The topic also describes complete programmatic management of SQL Server.