When I need to add columns to my publisher in a transactional replication I
use the sp_repladdcolumn. How do I Alter a column with no need to stop and
recreate the replication?
@.force_reinit_subscription has a default of zero, so I'm wondering if you
set this explicitly to 1? If not, are you really getting a reinitialization,
or just an indication that the existing snapshot is no longer applicable?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment