SQL Server SQL Server Distributed Management Objects , SQL Server. (Data Definition Languages), SQL-DMO .
SQL-DMO , , , . .
Microsoft SQL Server c , , (Component Object Model). MS SQL Server OLE Automation , [1]. , , , , , , ., ( ) Visual Basic, Visual C++, Visual J++, Visual FoxPro . .
, DMO , ( ). , SQL-DMO , .
DAO SQL-DMO SQL Server, OLE Automation. , , DAO DBEngine, . SQL-DMO Application, SQLServer, . SQL-DMO , . . 23.1 SQL-DMO Microsoft SQL Server 2000, . 23.2 , .
. 23.1
SQL-DMO Microsoft SQL Server 2000
. 23.2
SQL-DMO
. 23.2 . SQL-DMO.
SQLServer | , Microsoft SQL Server. |
Configuration | , Microsoft SQL Server. |
FullTextService | Microsoft Search full-text indexing. |
IntegratedSecurity | , logins Microsoft SQL Server. |
JobServer | , SQL Server Agent, , , . |
Registry | Microsoft Windows NT Microsoft Windows 95 , run-time- Microsoft SQL Server. |
Replication | , Microsoft SQL Server. . |
SQLServers | SQLServer, SQL-DMO. |
Databases | Database, Microsoft SQL Server. |
BackupDevices | BackupDevice, backup-, Microsoft SQL Server. |
Languages | Language, language- Microsoft SQL Server. |
LinkedServers | LinkedServer, OLE DB. |
Logins | Login, login-, Microsoft SQL Server. |
RemoteServers | RemoteServer, Microsoft SQL Server, . |
ServerRoles | ServerRole. |
, . , Databases ( ) Database, DBOption TransactionLog, DatabaseRoles, Defaults, Tables (. 23.3). , Tables (. 23.4) ClusteredIndex PrimaryKey Checks, Columns, Indexes, Keys Triggers .
|
|
. 23.3
Databases
. 23.4
Tables
SQLServer Connect, , . SQL-DMO : SQLServer, , SQLServer, SQLServer.
SQL-DMO , ( ) , SQLServer, Database, Table, Column . (, Name SQLServer, Database, Table, Column InPrimaryKey Column) . .