Microsoft KB Archive/70852

PRSQL9103032: Datatype Corrupt If Table Created by SELECT INTO ID Number: Q70852

1.10 OS/2 buglist1.10 fixlist1.11

Summary:

PROBLEM ID: PRSQL9103032

SYMPTOMS The timestamp for a new table created with the SELECT INTO command does NOT get updated when a row is inserted or updated.

CAUSE The SELECT INTO command, when used to create a table, does not correctly create the datatypes in the syscolumns table.

WORKAROUND Either of the following options will resolve the problem:

  Create the table without a timestamp field. Then, after creating the second table with SELECT INTO, add a timestamp field by altering this second table.   Modify the systems 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 

STATUS Microsoft has confirmed this to be a problem in SQL Server version 1.1. This problem has been corrected in SQL Server version 1.11, which is available from Microsoft Product Support Services. For more information, contact your primary support provider.