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