Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
murtaza_mmt
Starting Member
1 Post |
 Posted - 2011-01-21 : 04:56:00
|
| 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/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. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-01-21 : 05:53:16
|
| Hi do you have any table's column having datatype as TIMESTAMP? if so look for Insert statements in the code where this column is specified in the Column list of Insert .. Remove it from the list and corresponding values too ... Leave it to be filled with Default value.... |
 |
|
|
|
|
|
Replication system error - Cannot insert an explic