--========================================================================
-- GET A LIST OF SUBSCRIBERS
select
db_name() PublisherDB
, sp.name as PublisherName
, sa.name as TableName
, UPPER(srv.srvname) as SubscriberServerName
from dbo.syspublications sp
join dbo.sysarticles sa on sp.pubid = sa.pubid
join dbo.syssubscriptions s on sa.artid = s.artid
join master.dbo.sysservers srv on s.srvid = srv.srvid
exec sp_helppublication 'DB_pub'
GO
--Check if allow_anonymous=0,immediate_sync=0 or or not if not zero run below command
--Before running the sp_refreshsubscriptions SP, make sure that the publisher properties "allow_anonymous" and "immediate_sync" are set to "False",
-- if these 2 options are set to "True" then this SP will mark all the articles for
-- generating snapshot instead of marking only the newly added articles.
EXEC sp_changepublication
@publication = 'DBpub',
@property = N'allow_anonymous',
@value = 'false'
GO
EXEC sp_changepublication
@publication = 'DB_pub',
@property = N'immediate_sync',
@value = 'false'
GO
--Then add artciles
EXEC sp_addarticle @publication = N'DB_pub',
@article = N'LeadSourceGroup',
@source_object=N'LeadSourceGroup'
--========================================================================
-- Only add the subscribers if they don't exist
--========================================================================
--EXEC sp_addsubscription
-- @publication = N'mydatabase',
-- @article = N'OpenInvoiceAddress',
-- @subscriber = N'my_subscriber_01',
-- @destination_db = N'mydatabase'
--GO
-- EXEC sp_addsubscription
-- @publication = N'mydatabase',
-- @article = N'OpenInvoiceAddress',
-- @subscriber = N'SQLmy_subscriber_02',
-- @destination_db = N'mydatabase'
--GO
--Should on poublisher
EXEC sp_refreshsubscriptions @publication = N'db_pub'
GO
-- Start the Snapshot Agent job.This will only generetae snapshot for
--add 1 table or any tables adeed
EXEC sp_startpublication_snapshot @publication = N'DB_pub'
go
----MUST
--enable back
EXEC sp_changepublication
@publication = 'DB_pub',
@property = N'allow_anonymous',
@value = 'True'
GO
EXEC sp_changepublication
@publication = N'DB_pub,
@property = N'immediate_sync',
@value = 'true'
GO
