Installing SQL-DMO

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

SQL Server Database Management Objects (SQL-DMO) has been removed from SQL Server 2008 R2 Express and the SQL Server 2008 R2 Feature Pack. SQL-DMO also does not support Database Engine features introduced after SQL Server 2000. We recommend that you modify applications that currently use this feature as soon as possible. If you must support SQL-DMO, install the Backward Compatibility Components from the SQL Server 2008 Feature Pack from the Microsoft Download Center. Do not use SQL-DMO in new development work; use SQL Server Management Objects (SMO) instead. You can obtain the SMO documentation by installing SQL Server 2008 R2 Books Online.

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.




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.

To register the SQL-DMO components on a client computer

  • 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