SQL-DMO (Level 1)
SQL-DMO applications are administrative tools and should be updated to work with SQL Server 2000. It is recommended that code be recompiled and any error messages returned from the build process be used to track any necessary changes.
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| SQL-DMO is implemented in Sqlole.dll. The SQL-DMO objects exhibit properties, methods, and events that automate administrative tasks for SQL Server version 6.5 and earlier. SQL-DMO, implemented in Sqlole.dll, cannot connect to and operate against SQL Server 2000 or SQL Server 7.0. | SQL-DMO is implemented in Sqldmo.dll. These SQL-DMO objects expose the properties, methods, and events that automate administrative tasks for SQL Server. They cannot be used to connect to and operate against a SQL Server version 6.5 (or earlier) server. Therefore, it is recommended that you rewrite SQL-DMO applications.
If the application must operate against both SQL Server 2000 and version 6.5 or earlier of SQL Server, reference both Sqldmo.dll and Sqlole.dll components in the application. Develop new, separate subroutines referencing the SQL Server 2000 SQL-DMO objects from the existing subroutines. If the application will work against SQL Server 2000 only, rewrite existing subroutines to reference SQL Server 2000 SQL-DMO objects. If the application will not be used against your new SQL Server 2000 server(s), continue to use the application unchanged. |