Developing SQL-DMO Applications
未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。
SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating Microsoft SQL Server database management and replication management.
SQL-DMO is a dual interface COM in-process server implemented as a dynamic-link library (DLL). When creating a SQL-DMO application, you can use any OLE Automation controller or COM client development platform using C or C++.
SQL-DMO automates:
- Repetitive or commonly performed SQL Server administrative tasks.
- SQL Server object creation and administration.
- Creation and administration of SQL Server Agent jobs, alerts, and operators.
- SQL Server replication installation and configuration.
SQL-DMO documentation covers the components of SQL-DMO, their use in developing applications, and SQL-DMO application construction. It also includes a detailed component reference.