SQL Server 分布式对象体系结构及其应用

Structure of SQL Server Distributed Management Objects and Its Applications

目的论述ＳＱＬＳｅｒｖｅｒ分布式管理对象的体系结构，通过实例给出分布式管理对象在ＶＢ程序中的应用方法．方法通过对象存取技术（属性存取、方法存取、集合存取和列表存取）存取ＳＱＬＤＭＯ使用ＳＱＬＤＭＯ步聚，建立ＳＱＬＳｅｒｖｅｒ对象，为ＳＱＬＳｅｒｖｅｒ对象建立连接，以对象存取方法存取和释放ＳＱＬＳｅｒｖｅｒ对象及其它对象．结果ＳＱＬＤＭＯ体系结构可概括为应用程序、服务、服务器、数据库和表５个范畴．结论通过ＳＱＬＤＭＯ，程序员可以驾驭整个ＳＱＬ网络，操作网络中的任何一台ＳＱＬ服务器．

Aim To discuss the structure of SQL Server distributed management objects(DMO)and illustrate its use in VB applications Methods SQL DMO can be accessed through object accessing technology(property accessing,methods accessing,collections accessing and lists accessing) Steps in using SQL DMO objects are to create a SQL Server object,connect the SQL Server object,use the SQL Server object(or other contained objects)and then release the SQL Server object Results SQL DMO can be generalized into five scopes:application scope,service scope,SQL Server scope,database scope and table scope Conclusion Through the use of SQL DMO the whole SQL network can be controlled and any SQL Server in the network can be administered