Add article to merge publication cause, again applied to the subscribers every time the merge agent runs
in [Replication]
|
Prev: SQL Replication Presentation....
Next: free full ecm2001 titanium crack torrent rapidshare download free &(yPwzC@%n
From: Tom on 7 Oct 2009 15:41 Hi Ed, unfortunately no. I've tried to run sp_enumeratependingschemachanges to run sp_markpendingschemachange later - as Paul suggested. However, although sp_enumeratependingschemachanges does not show any pending changes, the schema changes are again and again applied. Tom U�ytkownik "ed" napisa� w wiadomo�ci news:2009930131429edbeo(a)hotmail.com... > Hi Tom, I have same issue, did you resolve it? > Ed > > > > Tom wrote: > > New article in the merge replication > 20-sep-09 > > Hello, > I have the following problem: > I have added a new article (table) to a merge publication on SQL 2005 STD. > For some reason, every time the merge agent runs (pull subscription), the > schema changes > are again applied to the subscribers. This does not happen with the > subscribers with reinitialized subscriptions. However if possible I would > like to avoid reinitialisation. What can I do to apply the schema changes > only once? > Thanks in advance. > Tom > > EggHeadCafe - Software Developer Portal of Choice > WPF DataGrid Custom Paging and Sorting > http://www.eggheadcafe.com/tutorials/aspnet/8a2ea78b-f1e3-45b4-93ef-32b2d802ae17/wpf-datagrid-custom-pagin.aspx |