Developing SQL-DMO Applications
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
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.