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

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:

                   : / \ * | ? " () [] {} <>

For more information about the use of special characters when you name objects, refer to the "Considerations for Naming Decision Support Objects" 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.