InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 01:51:24 GMT20http://www.sqlservercentral.com/Forums/Topic1051367-391-1.aspxHi 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/273Cannot 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/273What 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.Fri, 21 Jan 2011 01:05:58 GMTmurtaza_tinwala