BUG: SQL Server 2000 Enterprise Manager Taskpad May Not Show Tables in Table Info Tab (296434)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q296434
BUG #: 353634 (SHILOH_BUGS)

SYMPTOMS

In SQL Server 2000 Enterprise Manager, the Taskpad view may not show tables on the Table Info tab, and the following error message may display:
The specified table could not be found.
This error message also displays when you enter a table name in the Search for dialog box, and then click Go.

You may encounter this problem when the following conditions are met:
  • There is/are some large tables in the database.
  • There are problems with the sysindexes for some tables in the database. For example, misreported pages that are used or reserved on nonclustered indexes show in sysindexes on those tables.

CAUSE

The problem occurs because the total number of used or reserved nonclustered pages is too large.

WORKAROUND

The display problem could be indirectly related to the size of the table. The used or reserved pages for the nonclustered index can be large by nature. If there is a large nonclustered index on a large table, this issue might be seen. No workaround is available for this situation at this time. However, in the sysindexes system table, there may be a misreported used or reserved page value for one of the nonclustered indexes on that table. It means that the problem is not related to the size of the table, but is due to the misreported size of the nonclustered indexes in the sysindexes system table. You can attempt the following workarounds in order to correct the display in Enterprise Manager:
  • Run DBCC REINDEX on the problem tables to rebuild the index on the tables. -or-

  • Script out the database and re-create the database again. You can also use Data Transformation Services (DTS) to transfer the data.
Please note that the above workarounds are both time-consuming and performance intensive; this should be taken into consideration before implementing these workarounds. The display issue in SEM does not impact the performance or behavior of SQL Server in any way.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.

MORE INFORMATION

Steps to Reproduce Behavior

  1. In Enterprise Manager, select the database you want to use, right-click the database, select View, and then click Taskpad.
  2. Click the Table Info tab. The tables are not shown and the message described in the "Symptoms" section displays.
  3. In the Search for dialog box, type the table name and then click Go. The same message displays.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB296434
©2003 Microsoft Corporation. All rights reserved.