System error in replication - Cannot insert an explicit value into a timestamp column.

  • Hi members,

    I have set up transactional replication between two databases within same instance of SQL Server 2008 R2. I tested it and it worked fine 2-3 times. But somehow it has stopped working now. When I check the Replication Monitor > Distributor to Subscriber History, I find the following error in all synchronizations.

    Command attempted:

    if @@trancount > 0 rollback tran

    (Transaction sequence number: 0x000003C3000023F8004400000001, Command ID: 1)

    Error messages:

    Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column. (Source: MSSQLServer, Error number: 273)

    Get help: http://help/273

    Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column. (Source: MSSQLServer, Error number: 273)

    Get help: http://help/273

    What could be the reason for this error? It does not tell us in which internal operation this error occurs - neither any stack trace. How can we trace such errors?

    I have several solutions for resolving this error but nothing has worked. I removed subscriber and re-added it also.

    If anyone has faced similar issue before, please let me know solution.

Viewing 0 posts

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