What is SQL-DMO?

The SQL-DMO is a part of the Distributed Management Framework that Microsoft provides for SQL Server. This framework is three-tiered consisting of SQL Server, SQL-DMO, and SQL Executive. The SQL-DMO is the middle level that provides the interface to manage features of SQL Server. The SQL-DMO has its own hierarchy consisting of the application, SQL Server, database, and table objects. The important point to remember is that each level consists of objects related to the level. For example, the database level consists of stored procedure and table objects.

Files needed

Microsoft introduced SQL-DMO in SQL Server version 6.0. A good rule to observe is to use the proper version of SQL-DMO with the proper SQL Server. These DLL's are located within the BINN directory of your SQL Server.

SQL Server 6.0

SQLOLE32.DLL

SQL Server 6.5

SQLOLE65.DLL

SQL Server 7.0 & SQL Server 2000

SQLDMO.DLL - The names are the same, but they really are different. You can not access SQL Server 2000 using the SQL 7 SQL-DMO, although you can do vice-versa.

MSDE

SQLDMO.DLL - Both SQL 7 and SQL Server 2000 should work.

(Save your self some stress and just load the client tools for the given SQL Server on your web server!)