Microsoft KB Archive/308452

= FIX: SP1 Regression: Table Does Not Display in Taskpad View If the Table Name Contains a Special Character =

Article ID: 308452

Article Last Modified on 1/9/2002

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 1

-



This article was previously published under Q308452



BUG #: 355566 (SHILOH_BUGS)



SYMPTOMS
SQL Enterprise Manager (SEM) does not display tables that have a special character in their name from the Taskpad view. You can see this problem when you display all the tables from a given database.

To navigate to the Taskpad view, click a database name in Enterprise Manager, and then click Taskpad view on the View menu.

You can also see this problem when you search for the table by using the Table Info tab of the Taskpad view. Type in the exact table name that has a special character in the table name, and then press GO. The following error message appears:

The specified table could not be 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
To work around this problem, avoid the use of special characters when you name objects. Some objects have specific limitations regarding non-alphanumeric characters. The following characters are considered invalid for use in data source names:                   : / \ * | ? &quot; [] {} <>

For more information about the use of special characters when you name objects, refer to the &quot;Considerations for Naming Decision Support Objects&quot; topic in SQL Server 2000 Books Online.



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000 Service Pack 1.

This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.

Additional query words: slash bracket curly brace quote greater than less colon backslash asterisk star question mark parenthesis parentheses pipe

Keywords: kbbug kbfix KB308452

-

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

© Microsoft Corporation. All rights reserved.