Post reply

Replication on SQL2000 with timestamp column

  • January 12, 2004 at 10:03 am

    #162941

    I'm trying to add a timestamp column to a replicated table and get 'Cannot add identity column without forcing reinitialization'. Why is that ? Is there anyway get around without reinitialization the subscription ?

  • January 12, 2004 at 2:04 pm

    #489638

    Use sp_repladdcolumn.

  • January 12, 2004 at 2:04 pm

    #489637

    Use sp_repladdcolumn.

  • January 13, 2004 at 7:09 am

    #489736

    I did use sp_repladdcolumn and get this error. The exact syntatx: sp_repladdcolumn @source_object = 'Table_A' , @column = 'TA_TS' , @typetext = 'timestamp', @force_invalidate_snapshot = 0, @force_reinit_subscription = 0

  • January 23, 2004 at 8:01 am

    #491372

    sp_repladdcolumn is used for all types of replication.

    When using sp_repladdcolumn, if a schema change is made to an article that belongs to a publication that uses a DTS package, the schema change is not propagated to the Subscriber, and the custom procedures for INSERT/UPDATE/DELETE are not regenerated on the Subscribers. The user will need to regenerate the DTS package manually, and make the corresponding schema change at the Subscribers. If the schema update is not applied, the Distribution Agent may fail to apply subsequent modifications. Before making a schema change, make sure there are no pending transactions to be delivered. For more information, see How Transforming Published Data Works.

    When typetext is assigned a default value that is a nondeterministic function (for example, 'datetime not null default getdate()'), non-convergence can occur after adding the new column because the function will be executed at the subscriber in order to load a default value into the column. 

    Timestamp and computed columns will be filtered out for character mode publications. If adding a timestamp or computed column using sp_repladdcolumn, subscriptions of such publications will not receive this new column.

    Important  A backup of the publication database should be performed after sp_repladdcolumn has been executed. Failure to do so can cause a merge failure after a restore of the publication database.

  • January 23, 2004 at 8:14 am

    #491381

    I got correct answer from Microsoft. You can't add timestamp or any calculate column to the replicate database without re-initialize the snapshot.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply