Accessing SQL Server programmatically with SQL Server Management Objects (SMO)
SQL Server 2005 and 2008 provide SQL Server Management Objects (SMO), a collection of namespaces which in turn contain different classes, interfaces, delegates and enumerations, to programmatically work with and manage a SQL Server instance. SMO extends and supersedes SQL Server Distributed Management Objects (SQL-DMO) which was used for SQL Server 2000. In this article, I discuss how you can get started with SMO and how you can programmatically manage a SQL Server instance with your choice of programming language. Click here for more details....