System Requirements for 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.

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 2005 client workstation installation. See Installation Options 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 Microsoft SQL Server 2005. The Transact-SQL script Sqldmo.sql is shipped with Microsoft SQL Server 2005 and can be used to reinstall the required stored procedures if necessary.

Community Additions