Microsoft KB Archive/302676

= PRB: SQL Enterprise Manager Does Not Retain All Custom View Settings =

Article ID: 302676

Article Last Modified on 9/26/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



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:  Create a new registry key of type DWORD as follows:

HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MMC/SETTINGS/MAXVIEWITEMSPERSISTED

 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.



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.

Keywords: kbqfe kbprb kbpending kbhotfixserver KB302676

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.