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

Sqldmo.dll

DLL implementing SQL-DMO objects.

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

Sqldmo80.hlp

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

Sqldmo.rll

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

Sqldmo.h

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

Sqldmoid.h

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

\Program Files\Microsoft SQL Server\MSSQL\Install

Sqldmo.sql

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

ALL

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

ADD
Show: