AspDotNetAtoms.com provides daily updates on ASP.NET Tutorials, Programming Resources, .NET Articles, Authors and more.

Categories

Recent Posts

Perform Database Administration Operations with SQL Server Management Objects : John Papa

Wednesday, July 30 2008

Not only must database developers query and manipulate data, but they must also perform administrative tasks on a regular basis. SQL Server™ Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition Language (DDL) commands. Using SQL SMO you can also connect to SQL Server, iterate through a collection of database objects and perform a variety of tasks against them. In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks. Specifically, I cover topics such as how to design your project to use SMO and how to connect to a server. I also walk through a sample application that issues DDL or Data Manipulation Language (DML) commands against the database. Finally, I demonstrate how to use SMO to perform database backups, restores, and backup verification.

Read More:
Perform Database Administration Operations with SQL Server Management Objects : John Papa
Also See:
Changing GridView Column Color : AzamSharp
Learn The Basics Of LINQ : Timothy Khouri
SOS: Upcoming release has a few new commands – HeapStat : ASP.NET Debugging
ObjectDataSource in Depth (Part 2) : Manuel Abadia
Integrate Windows Live ID Authentication with ASP.NET Membership, Profiles and Roles : Peter A Bromberg

Post your comment

Comment