In merge replication we have following issue which appears from time to time in few subscriptions.
When I added new column to table by using following procedure:
sp_repladdcolumn @source_object = N'TABLE_NAME'
,@column = N'NEW_COLUMN_NAME'
, @typetext =N'tinyint null'
, @publication_to_add = N'PUBLICATION_NAME'
, @from_agent = 0
, @schema_change_script = null
, @force_invalidate_snapshot = 0
, @force_reinit_subscription = 0
replication for few subscriptions gets following error:
The schema definition of the destination table 'dbo'.'TABLE_NAME'
in the subscription database does not match the schema definition of the source table in the publication database. Reinitialize the subscription without a snapshot
View Complete Post