This sample illustrates using SQL Distributed Management Objects (SQL-DMO) objects supplied with Microsoft® SQL Server™ 2000. This Microsoft® Visual Basic® sample traverses the DMO object model, displaying its values. It does this by using the Typelib Information COM Object to read the type library exposed by SQL DMO. This technique can be used to show the object model of a COM object, but it is not recommended in a production environment.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Sqldmo\Vb\DMOExplorer