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