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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » System error in replication - Cannot insert...

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

Rate Topic

Display Mode

Topic Options

Author

Message

murtaza_tinwala

Posted Friday, January 21, 2011 1:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 21, 2011 1:06 AM
Points: 1, Visits: 2

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.

Post #1051367

« Prev Topic | Next Topic »

Permissions