Microsoft KB Archive/275024

= FIX: SQL Server Enterprise Manage Does Not List all Tables in the TaskPad View and the Next and Last Buttons Do Not Appear =

Article ID: 275024

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q275024



BUG #: 236420 (SHILOH_BUGS)



SYMPTOMS
When a database contains several tables, the SQL Server Enterprise Manager does not list all of the tables in the Table Info tab of the Taskpad view of that database. Although a scroll bar does appear, scrolling down does not display all of the tables. However, if you enter a table name in the Search for text box that you know exists and you then click GO, that table is found.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
The Next and Last buttons will appear if you click GO either without entering anything in the Search for text box when there are more than 22 tables in the database, or after you perform a search by using wildcards that returns more than 22 tables.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.

Keywords: kbbug kbfix KB275024

-

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

© Microsoft Corporation. All rights reserved.