EM Task Pad Table Info -- Specified Table Not Found
-
In Enterprise Manager, if I select Taskpad from the View menu and then navigate to the Table Info area, EM does not show any table info. It simply shows the "Search for" area and the rest of the page reads "The specified table could not be found". Normally, I get a listing of all tables along with the number of rows, size of the table and associated indexes.
Can anyone tell me why this is happening or what I need to change to get this information to be viewable? This only happens on some databases, not all of them. On others, this information is available. Are there option settings that need to be set for each database or what?
Thanks in advance!!!
Brian
-
Apparently this is a bug with EM. I applied SP3a and it appears to be fixed.
-
Although it seems to be getting better with SP3(a), it is still not completely fixed. My bet is that Microsoft is doing this intentionally to keep user from using EM to use QA, which is better
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Can I get the same type of information from Query Analyzer -- # of records, size of table in KB, etc. ???
What is the sproc or t-sql to get this info?
-
Sure you can!
Take a look at sp_spaceused in BOL. I would also search the script section here. This will surely return several useful hits.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Thanks Frank!!! I know when I see your name, I'm going to get some good information. I appreciate it!!!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply