Microsoft KB Archive/255041

= BUG: DTS Designer Does Not Show Columns in Build Query if Database Name is Non ANSI =

Article ID: 255041

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q255041



BUG #: 57579 (SQLBUG_70)



SYMPTOMS
If you have a database that uses a non-ANSI name convention (for example, a space in its name or a database name that begins with a number), when you use the Data Transformation Services (DTS) Designer to build a query, you will not see any of the individual columns for any of the tables in the database. All you see is "(All Columns)" for each of the tables in that database.



WORKAROUND
Rename the database by using the SP_RENAMEDB stored procedure to eliminate or replace the space(s) in the database name.



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

Keywords: kbbug kbpending KB255041

-

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

© Microsoft Corporation. All rights reserved.