Prev: Error Using the "Copy permissions" setting for articles
Next: Merge Repl: Changing Profiles Has No Effect
From: dbaeiss on 27 Jan 2010 07:14 We have peer to peer rep setup in SQL 2008. We have added a new column called 'setby' to a table using alter table tableA add [SetBy] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO This is added succesfully on both sides. Upon restarting replication we get "Invalid column name" Steby http://help/207 Any thoughts?
From: dbaeiss on 8 Feb 2010 05:26
Hi paul Yes it was a typo. This issue turned out to be a "production restore" issue. The Prod backup was loaded into QA, then schema changes applied. Rep came up with errors. Looking at sp_browsereplcmds, I could see a schema mismatch in the offending txn id.. The fix was to restore replication after the restore in QA, then apply changes. The issue was on the exception table for the recently changed table. DEV team now aware of good process. "Paul Ibison" wrote: > Are you sure there is no typo in the post - the alter table says setby and > the error refers to steby? > Cheers, > Paul Ibison > |