The SQL Namespace Browser is a sample SQL-NS application. Use it 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.
Sample Microsoft® Visual Basic® code for the SQL Namespace Browser is located in the \Mssql7\Devtools\Samples\Sqlns\Vb\Browse directory. Use these files:
| About.frm | Browse.vbw |
| Browse.frm | Edit.frm |
| Browse.vbp | Sqlns.bas |
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 server or database. |
| Server Group | Enter the name of the server group to browse when the Root Object is server group. |
| User | Enter the user name to use to connect to a server. |
| Password | Enter the password to use to connect to a server. |
| Integrated Security | Connect to a server using integrated security. |
| Database | Enter the name of the database to browse when the Root Object is database. |
| Connect | Begin browsing at the specified Root Object and log in to a server or database if necessary. |
| 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. |