I am using SQL Server 2005 Developer Edition for Creating & Testing Database.
I had created Merge Publication WITHOUT FILTERING ROWS and Created Push or Pull Subscription. Now if I Add or Drop column using ALTER TABLE (T-SQL) in Table OR modify stored procedure using ALTER PROCEDURE in
Published Database then while Synchronizing It replicate same in Subscriber Database and works very fine.
But when I had created Merge Publication WITH FILTERING ROWS (Parameterize or Static) and Created Push / Pull Subscription and I try to Add or Drop column
using ALTER TABLE (T-SQL) in Table OR modify stored procedure using ALTER PROCEDURE in Published Database then while Synchronizing It
DOESN'T REPLICATE in Table of Subscriber Database but
tries Replicate in Stored Procedure and display error.
After Adding Column in Table of Published Database, If I Checked Article in property of Publication then it Adds column but it doesn't
selects it. I also checked using sp_enumeratependingschemechenges it displays pending schema changes of stored procedure but
View Complete Post