When you run Meta Data Browser as a stand-alone snap-in, you can set a browse mode at the repository database level to determine the scope of actions that are available to you. Browse modes include End User, Power User, and Administrator. You can choose different browse modes for each database.
The scope of actions for each browse mode includes the following:
Browse modes apply exclusively to repository databases and have no impact on Microsoft® SQL Server™ 2000 user modes, Microsoft Windows NT® 4.0 user modes, or Microsoft Windows® 2000 user modes. In other words, being a repository Administrator does not confer administrator rights in SQL Server.
You cannot change the browse mode if you are running Meta Data Browser from within SQL Server Enterprise Manager. From within SQL Server Enterprise Manager, Meta Data Browser can only be run in End User mode.
To set a browse mode, you must select it during database registration. The browse mode you select is part of the registration information. To select a different browse mode, you must edit registration properties. For more information about the scope of actions each user mode supports, see Database Registration Properties Dialog Box.
Editing Registration Properties in Meta Data Browser
Registering a Repository Database in Meta Data Browser