Sometimes you may need  your application to work on a slow or time- consuming task in such a way that your user isn't kept waiting unnecessarily while this is happening.

   The answer to this problem is to use multithreading.   Having seen many forum questions about multithreading, I've always been a bit apprehensive about tackling it.  However,  as it turns out, the BackgroundWorker component is versatile  and easy to use, providing a painless solution to this requirement. 

   In this article I will show you how you can  incorporate the BackgroundWorker into your projects to give your users a more professional and less frustrating experience.

Introduction

SQL Server Management Objects (SMO) is a collection of objects that allow you to work with SQL Server 2005 databases in a managed environment. Previous to SQL Server 2005 you could use SQL Server Distributed Management Objects (DMO) to work with SQL Server 6.0, 6.5, 7 and 2000 (including MSDE) servers. For the most part, the objects provided with SMO will also work with SQL Server 2000, only those features specific to SQL Server 2005 will not work against a 2000 server.

This article aims to introduce a few of the basic operations that can be performed using SMO such as connecting to an SQL Server, managing databases, tables and stored procedures and performing backup and restore operations against an SQL Server.