Ads

27 May 2014

Add Article Replication _Simpler Way

Use Test_Model
go
Exec sp_changepublication 'Test_model_pub','allow_anonymous',false
GO
Exec sp_changepublication 'Test_model_pub','immediate_sync',false
GO

sp_addarticle 'Test_model_pub', product5, @Source_object=product5
GO
sp_refreshsubscriptions 'Test_model_pub'

GO
sp_startpublication_snapshot 'Test_model_pub'

No comments:

Post a Comment