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:
1. 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.
2. 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.