System Requirements for 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 Distributed Management Objects (SQL-DMO) uses the Microsoft SQL Server ODBC driver to connect to and communicate with instances of SQL Server. Stored procedures supporting SQL-DMO are installed on each instance of SQL Server.
SQL-DMO clients requires SQL Server client workstation installation. See Client Network Configuration for information about the operating system requirements.
SQL-DMO clients require SQL Server ODBC Driver, version 3.80 or later, which is installed with SQL Server 2000 and later. The client network library must be properly configured.
SQL-DMO locates instances of SQL Server using the name of the instance. SQL-DMO does not use ODBC data source definitions for connection, and you need not use the ODBC Administrator to create data source definitions for servers administered by SQL-DMO applications.
Stored procedures that support SQL-DMO are created as part of an instance of SQL Server. The Transact-SQL script Sqldmo.sql is shipped with SQL Server and can be used to reinstall the required stored procedures if necessary.