---
title: "Link to Programming Samples | Microsoft Docs"
ms.custom: ""
ms.date: "03/06/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: "database-engine"
ms.topic: "reference"
helpviewer_keywords: 
  - "sample applications [SMO]"
  - "SMO [SQL Server], samples"
  - "SQL Server Management Objects, samples"
ms.assetid: 5eb28044-8437-466e-9c55-60941c237fbb
author: mikeraymsft
ms.author: mikeray
manager: craigg
---
# Link to Programming Samples
  The following table lists the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Management Objects (SMO) programming samples that are available in the [!INCLUDE[ssSampPathEng](../../includes/sssamppatheng-md.md)]Programmability\SMO directory. These samples are available in both [!INCLUDE[csprcs](../../includes/csprcs-md.md)] and [!INCLUDE[vbprvb](../../includes/vbprvb-md.md)] .NET.  
  
 For more information about how to install samples, see [AdventureWorks for SQL Server 2012](https://msftdbprodsamples.codeplex.com/releases/view/55330).  
  
|Title|Description|  
|-----------|-----------------|  
|BackRest|Demonstrates how to back up and restore a database.|  
|ChangeTableOwner|Demonstrates how to change ownership of all tables that are not dbo to dbo.|  
|CreateSPs|Demonstrates how to create a `SELECT` stored procedure for each table in the selected database.|  
|DatabaseSearch|Displays all the objects in a database.|  
|DependencyExplorer|Implements dependency tree and property display window.|  
|IndexSizes|Displays index name and size for the selected database.|  
|LoadRegAssembly|Demonstrates how to load and register a [!INCLUDE[msCoName](../../includes/msconame-md.md)] .NET Assembly into [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. Uses the UtilityConversion assembly.|  
|ManageDatabases|Demonstrates how to create, alter, and drop a database. Includes adding a new file group and log file.|  
|ManageDatabaseUsers|Demonstrates how to add, modify, and remove users.|  
|ManageTables|Demonstrates how to create, alter, and drop tables.|  
|ScriptJobs|Demonstrates how to script the dropping and creating of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent jobs.|  
|ScriptTable|Demonstrates how to script the dropping or creating of a table.|  
|ServerConnect|Demonstrates how to connect to the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] system.|  
|ServerInfo|Displays a list of server and connection properties for the selected instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].|  
|SMOPing|A console application that connects to the selected instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] and dumps selected properties. Can be used to check the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] connection.|  
|SQLServerList|Enumerates a list of available instances of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].|  
|SQLService|Displays the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services that are available to start, stop, pause, and resume.|  
|Tracer|Reads and displays trace information from an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].|  
|Triggers|Displays database triggers.|  
|UtilityConversion|Used with `LoadRegAssembly`. Contains demonstration common language runtime (CLR) functions for use with [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].|  
|VerifyBackup|Verifies a backup on a backup device to ensure the data can be used to restore the database.|