November 20, 2005 at 10:05 pm
Hi,
I have set up transactional replication with immediate updating and queued failover. On the publisher I can insert a new record and it will be transfered to the subscriber. If I try and update a field I get an error saying...
Anoth user has modified the contents of this table or view; the database row you are modifiing no longer exists in the database. Database Error: '[MicroSoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near ')'. [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@c72o'.'
Does anyone have a hint as to where to look. I have deleted the tables on the subscribor and had the snapshot recreate them but no change.....
Allan
November 22, 2005 at 5:43 am
It is a known bug in SQL Server versions prior to SP4. Just apply SP4 and works fine. (sorry, can't find the Microsoft Document where it is explained) Hope this helps
Regards
Javier Prieto
January 13, 2006 at 8:18 am
I am having the same same replication issue. I have SP4 installed on all SQL Servers but still recieve the same message. I have deduced that an update trigger is causing the error. I have tried adding the 'NOT FOR REPLICATION' option to the trigger but it does not make a difference. Am I able to use an update trigger on a table that is using bidirectional transactional replication?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply