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

Structure of SQL Server Distributed Management Objects and Its Applications

  • 摘要: 目的论述SQL Server分布式管理对象的体系结构,通过实例给出分布式管理对象在VB程序中的应用方法。方法 通过对象存取技术(属性存取,方法存取,集合存取和列表存取)存取SQL-DMO。使用SQ2L-DMO步骤建立SQLServer对象,对SQ2LServer对象建立连接,以对象存取方法存取和释放SQL Server对象及其它对象。结果SQL-DMO体系结构可概括为应用程序,服务,服务器,数据库

     

    Abstract: 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

     

/

返回文章
返回
Baidu
map