Solved

Taskpad not showing database sizes

Posted on 2004-08-13
11
246 Views
Last Modified: 2012-06-21
For some reason, my Enterprise Manager taskpad stopped showing data in the "Space Allocated" section. Not serious, but annoying. I can see the data if I select the database and view Options. The dropdowns for changing database sizes work fine. This affects all servers I look at with this client, so it is definitely client side (other clients on this network are fine).

I have already replaced the "SQL Server Enterprise Manager.MSC" file, taking one from a good machine, thinking that that file controlled this, but that did not work.

Does anyone know how to fix this problem?

Thanks,

Aaron
0
Comment
Question by:AaronAbend
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 17

Expert Comment

by:BillAn1
ID: 11792065
I think taskpad is still quite buggy. I have seen this happen many times, no clear answer.
One thing that has helped, is to change the view from task-pad to list, and back again. This appears to correct some problems. But as you say it is only annoying, not serious, so I've never taken the effort to get to the bottom of it.
0
 
LVL 10

Author Comment

by:AaronAbend
ID: 11792484
As a matter of fact, I discovered that view-change trick a few years ago and tried it already. That does fix the script error that happens on a regular basis in EM. But this is much more persistent than any similar problems I have had in the past, and that trick at least did not work. Any other tricks?

0
 
LVL 17

Expert Comment

by:BillAn1
ID: 11792597
sorry, no other suggestions.
Are you on the latest SP of SQLServer? I don't think I have seen the problem in recent months, so it could be it was fixed, or it might just be coincidence.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 34

Expert Comment

by:arbert
ID: 11793564
Agree--makes sure you have SP3a on both the server and your client tools.  Might also think about reinstalling MDAC and making sure you have the lates IE patch...
0
 
LVL 10

Author Comment

by:AaronAbend
ID: 11793704
I am on SP3a. The other things may take a while for me to try, but I will. Thanks.
0
 
LVL 34

Accepted Solution

by:
arbert earned 50 total points
ID: 11795862
Ya, this is really more of an MMC/IE issue than a SQL server tools issue....Might check the version of your MMC as well....
0
 
LVL 10

Author Comment

by:AaronAbend
ID: 11795998
Makes sense. I know that IE gets hosed when I am using EM to do an index build or something (though I normally do those operations in Query Analyzer). I will not be able to test until Monday.

0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 11797501
EM-> view ->  details
Then
EM-> view -> taskpad

-----------------------------------
Hope 2005 will not have  this one - just new :)
0
 
LVL 34

Expert Comment

by:arbert
ID: 11802951
"Hope 2005 will not have  this one"


If you know anything about 2005 at all, you know the interface isn't even close to being the same...
0
 
LVL 10

Author Comment

by:AaronAbend
ID: 11894242
I have not had time to check this, but I think Brett is on the right track. I will post when I get around to fixing it.
0
 
LVL 10

Author Comment

by:AaronAbend
ID: 12095245
Just to let everyone who helped on this... I ended up too busy to test arbert/Brett's suggestion.  And I recently bought a new computer and deinstalled SQL from the old computer so I will never know (presuming it does not happen again!).

0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question