Microsoft KB Archive/69818

Q+E Fails on SQL Server Tables Created with SELECT INTO PSS ID Number: Q69818 Article last modified on 12-18-1992

1.10 1.11

OS/2

Problem:

I have several tables in a database which were created with the SELECT INTO command. When using Q+E, I am able to open the tables and select data from them. However, if I attempt to use the Define option to view the datatypes and lengths of the columns, I receive an error message telling me that the table does not exist.

Response:

When the “File Define tablename” option is selected, Q+E queries the syscolumns and systypes tables to determine the datatype of each column. However, due to a problem with SQL Server version 1.10, when a SELECT INTO is performed on a table, the usertype column of the syscolumns table fails get updated with the datatypes of the original table. Since Q+E cannot find any valid datatypes, it assumes the table does not exist.

Either of the following options will resolve the problem:

  Bulk copy the data out of the affected table, drop the table, use CREATE DATABASE to re-create the table, then bulk copy the data back in.   Modify the system tables in the database containing the affected table. For more information on this procedure, query on the following words: prod(sqlndk) and syscolumns and sp_help 

Microsoft has confirmed this to be a problem with SQL Server version 1.10. The problem was corrected in SQL Server version 1.11, which is availible from Microsoft Product Support Services. For more information, contact your primary support provider.

Additional reference words: 1.10 1.11

=
================================================================

Copyright Microsoft Corporation 1992.