PRB: SQL Enterprise Manager Does Not Retain All Custom View Settings (302676)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
This article was previously published under Q302676
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

If you set custom view settings (for instance, large icons, small icons, list, or detail) for a large number of nodes (for instance, database, users, logins, tables, jobs, and so on) in the tree structure of the SQL Enterprise Manager (SEM) console, the settings may not be retained for all nodes when SEM is closed and then reopened. The view settings return to the defaults.

CAUSE

By default, Microsoft Management Console (MMC) saves settings for only the first 70 nodes/objects per snap-in in the corresponding *.msc file. After this number is reached, it starts resetting the view settings to the defaults specified for the snap-in.

WORKAROUND

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To work around this problem, follow these steps:
  1. Create a new registry key of type DWORD as follows:

    HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MMC/SETTINGS/MAXVIEWITEMSPERSISTED

  2. Set the value to a large number; for instance, 500.
This key is checked when the snap-in opens. The custom view settings are retained for the number of objects as specified in this key.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create 10 to 15 databases on the server.
  2. In SEM, change the view settings from the default values to different values for each and every node in the tree structure.
  3. Close and then reopen SEM. The view settings will return to the default for some nodes.
Modification Type:MinorLast Reviewed:9/26/2005
Keywords:kbHotfixServer kbQFE kbpending kbprb KB302676
©2004 Microsoft Corporation. All rights reserved.