This sample Microsoft® Visual Basic® application demonstrates how to view the SQL Namespace object hierarchy, and view and execute the commands available for each object. The browser also displays the SQLNSObjectType and SQLNSCommandID for your selections.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Sqlns\Vb\Browse
Open the Microsoft Visual Basic project file, Browse.vbp, and then start the project.
This table describes the function of each item on the user interface.
| Use this | To do this |
|---|---|
| Root Object | Select the highest level object to be shown in the browser. |
| Server | Enter the name of the server to connect to when the Root Object is a server or database. |
| Server Group | Enter the name of the server group to browse when the Root Object is a server group. |
| User | Enter the user name to connect to a server. |
| Password | Enter the password to connect to a server. |
| Integrated Security | Connect to a server using the integrated security. |
| Database | Enter the name of the database to browse when the Root Object is a database. |
| Connect | Begin browsing at the specified Root Object and then, if necessary, log on to a server or database. |
| Disconnect | Disconnect from any servers or databases and stop browsing. |
| SQL Namespace Browser | View the SQL Namespace object hierarchy. |
| Commands | View and execute the commands available for the object selected in the SQL Namespace Browser. |
| Refresh | Refresh the SQL Namespace Browser. |
| Execute | Execute the command selected in the Commands list. You can also execute a command by double-clicking it in the Commands list. |