link-to-programming-samples.md

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 [!INCLUDEssNoVersion] Management Objects (SMO) programming samples that are available in the [!INCLUDEssSampPathEng]Programmability\SMO directory. These samples are available in both [!INCLUDEcsprcs] and [!INCLUDEvbprvb] .NET.

For more information about how to install samples, see AdventureWorks for SQL Server 2012.

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 [!INCLUDEmsCoName] .NET Assembly into [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. 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 [!INCLUDEssNoVersion] Agent jobs.
ScriptTable	Demonstrates how to script the dropping or creating of a table.
ServerConnect	Demonstrates how to connect to the [!INCLUDEssNoVersion] system.
ServerInfo	Displays a list of server and connection properties for the selected instance of [!INCLUDEssNoVersion].
SMOPing	A console application that connects to the selected instance of [!INCLUDEssNoVersion] and dumps selected properties. Can be used to check the [!INCLUDEssNoVersion] connection.
SQLServerList	Enumerates a list of available instances of [!INCLUDEssNoVersion].
SQLService	Displays the [!INCLUDEssNoVersion] services that are available to start, stop, pause, and resume.
Tracer	Reads and displays trace information from an instance of [!INCLUDEssNoVersion].
Triggers	Displays database triggers.
UtilityConversion	Used with LoadRegAssembly. Contains demonstration common language runtime (CLR) functions for use with [!INCLUDEssNoVersion].
VerifyBackup	Verifies a backup on a backup device to ensure the data can be used to restore the database.