Adjust TIMESTAMP fields

  • Article

You must change the TIMESTAMP field value on three tables. The TIMESTAMP fields are updated every time a row is modified for any reason. When this modification is replicated without any change to the table, the replication fails. Since the replication attempts to update the field in the row, it results in a break (the TIMESTAMP field is not updateable outside the SQL system affecting the change).

A nullable TIMESTAMP variable is semantically equivalent to a varbinary (8) and a non-nullable TIMESTAMP variable is semantically equivalent to a binary (8). There are three tables that require this change.

Change the following two tables to Binary (8):

  • CatalogCustomCatalogs, TimeStamp field
  • CatalogGlobal, TimeStamp field

Change the following table to a Varbinary (8):

  • CatalogName_CatalogProducts, TimeStamp

Copyright © 2005 Microsoft Corporation.
All rights reserved.