Using SQLDMO

Posted on August 26th, 2006 Mitch Milam  Print No comments

The Microsoft SQLDMO library is very handy should you need to perform functions that can normally be found in SQL Enteprise Manager such as:

• Creating databases
• Backing up a database
• Restoring a database
• Finding SQL Servers
• Enumerating databases found on a particular server
• Etc.

I've been working on a couple of applications that use many of the features of SQLDMO and have found the following articles to be very useful, should you need to use SQLDMO yourself:

How to distribute and how to install SQL-DMO for SQL Server 2000 

PRB: "SQLDMO Has Not Been Registered" Error Message If You Remove SQL Server Desktop Engine

This article is important because if you follow the instructions outlined in the first article on how to distribute SQLDMO, you can actually break SQLDMO should you ever uninstall your application. The uninstall will not delete SQLDMO, should it previously exist, but it will unregister it, which will, in effect, make it unusable to any other applications that attemp to use it.

Development

(No Ratings Yet)

 Loading ...

1,054 views