Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

System error in replication - Cannot insert an explicit value into a timestamp column. Expand / Collapse
Author
Message
Posted Friday, January 21, 2011 1:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse