Link to Programming Samples
The following table lists the SQL Server Management Objects (SMO) programming samples that are available in the C:\Program Files\Microsoft SQL Server\100\Samples\Engine\Programmability\SMO directory. These samples are available in both Visual C# and Visual Basic .NET.
For more information about how to install samples, see Samples (Database Engine) in SQL Server Books Online.
Demonstrates how to back up and restore a database.
Demonstrates how to change ownership of all tables that are not dbo to dbo.
Demonstrates how to create a SELECT stored procedure for each table in the selected database.
Displays all the objects in a database.
Implements dependency tree and property display window.
Displays index name and size for the selected database.
Demonstrates how to load and register a Microsoft .NET Assembly into Microsoft SQL Server. Uses the UtilityConversion assembly.
Demonstrates how to create, alter, and drop a database. Includes adding a new file group and log file.
Demonstrates how to add, modify, and remove users.
Demonstrates how to create, alter, and drop tables.
Demonstrates how to script the dropping and creating of SQL Server Agent jobs.
Demonstrates how to script the dropping or creating of a table.
Demonstrates how to connect to the SQL Server system.
Displays a list of server and connection properties for the selected instance of SQL Server.
A console application that connects to the selected instance of SQL Server and dumps selected properties. Can be used to check the SQL Server connection.
Enumerates a list of available instances of SQL Server.
Displays the SQL Server services that are available to start, stop, pause, and resume.
Reads and displays trace information from an instance of SQL Server.
Displays database triggers.
Used with LoadRegAssembly. Contains demonstration common language runtime (CLR) functions for use with SQL Server.
Verifies a backup on a backup device to ensure the data can be used to restore the database.