Hi, I really need help as this is working on production environment and I have no idea what's happening.
We have a SQL Server 2008 Merge Publication (Merge Pull Replication)
All subscribers are running SQL Server Express 2008.
The replication has been working fine for 4 month, yesterday we noticed that one column of a Table were out of the publication article. BTW, it was replicated originally... we don’t know how it disappeared…
So we executed:
exec sp_mergearticlecolumn @publication = N'IPoint_Pub', @article = N'Tipo_Empleado', @column = N'Row_Version', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
After that, ALL subscriptions failed to sync returning the error:
A dynamic snapshot is required because the publication 'IPoint_Pub' contains both dynamic filters and logical record relationships.
Obviously I did executed the jobs for creating the main snapshot (static) and also all the dynamic snapshots after checking the main snapshot was successfully generated.
In some subscribers, dropping the su
View Complete Post