Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This topic provides an overview of administering the Database Engine programmatically.
Database Engine administration programming is concerned with three APIs: SMO (including RMO and NMO), SQL-DMO, and WMI. These three API sets let the programmer write programs that manage the SQL Server Database Engine. They represent programming interfaces that provide the data definition language (DDL) for SQL Server.
SQL Server Management Objects (SMO)
WMI and SQL Server
SQL Distributed Management Objects (SQL-DMO)