Installing SQL-DMO

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

All required SQL Distributed Management Objects (SQL-DMO) components are installed as part of an instance of Microsoft SQL Server on the server or client. SQL-DMO is implemented in a single dynamic-link library (DLL). You may develop SQL-DMO applications on either a client or a server. When using an OLE Automation controller as a development platform, such as Microsoft Visual Basic, no additional files are required. Application development using C or C++ requires the SQL-DMO header files.

SQL-DMO sample applications, providing additional reference material for SQL-DMO application development, are included with SQL Server.

Directory File Description

C:\Program Files\Microsoft SQL Server\80\Tools\Binn


DLL implementing SQL-DMO objects.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn


SQL-DMO help file used within the development environment to provide context sensitive help about SQL-DMO objects, properties and methods.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\ Resources\xxxx


Localized resource file. The resource directory varies based on the national language of the instance of SQL Server client or server. For example, the directory 1033 is a decimal representation of the language identifier 0X0409, indicating English, U.S.

C:\Program Files\Microsoft SQL Server\80\Tools\ Devtools\Include


C/C++ header file containing SQL-DMO member function prototypes, enumerated data types, and macros.

C:\Program Files\Microsoft SQL Server\80\Tools\ Devtools\Include


C/C++ header file containing SQL-DMO interface and class identifiers.

\Program Files\Microsoft SQL Server\MSSQL\Install


Transact-SQL script implementing stored procedures that support SQL-DMO. Available on SQL Server server-instance only.

C:\Program Files\Microsoft SQL Server\80\Tools\ Devtools\Samples\Sqldmo


Sample applications illustrating SQL-DMO use.

To register the SQL-DMO components on a client computer
  1. From C:\Program Files\Microsoft SQL Server \90\Tools\Binn\Resources\<language> directory, execute:

    %Program Files%\Microsoft SQL Server\80\Tools\Binn\REGSVR32 SQLDMO.DLL

Community Additions