Enterprise Manager

[robwheels]

When I select taskpad view in SQL 2000, it never remains at that view next time I open enterprise manager. Is there a way to make taskpad view my default view each time enterprise manager is open?

 

[Flloyd]

There are a couple of things that may help you out.

First, find the shortcut to Enterprise Manager and check the properties. The target should be something like C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC". Change the /s to a /a (author mode) and apply.

Now open SEM using that shortcut and set the views the way you want throughout. When finished, exit SEM and reply 'Yes' to save the console settings. You can then reset the target string by changing the /a back to a /s. SEM should now retain the settings as you had set them before saving in author mode.

The other tip you may find useful is to choose Tools/Options and on the Advanced tab check the box for "Open the console tree to the last active node" if you want SEM to open the tree where you left it last time you exited.

Lloyd Freiday

 

[robwheels]

Thanks for the assistance, but it did not work. Is there another way?

 

[Flloyd]

I can't think of why that wouldn't work for you. I checked it on my SEM to confirm and it is saving the last position in the tree and displaying the taskpad view for that database ok.

I guess you should make sure that visit the DB's you want to have the taskpad view on and select that view while in author mode, then make sure you save the console settings when exiting.

I do know that there were some issues in taskpad that were resolved with S2K-SP3 so you may also want to apply that SP and recheck the results.

Lloyd Freiday