January 21, 2011 at 1:05 am
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