all groups > sql server replication > january 2007 >
You're in the

sql server replication

group:

publication include new tables created automatically?


publication include new tables created automatically? Maani
1/30/2007 2:20:00 AM
sql server replication: Hi All,

I have a merge replication on a SQL 2000 database to a remote site.
I have selected "publish all" in publication properties. Now if I a new
table is created, does it automatically runs the snapshot agent and include
that table in to the table schema????

Thanks in advance for the answer... :-)
Re: publication include new tables created automatically? Paul Ibison
1/30/2007 11:24:46 AM
Using sp_addmergearticle followed by running the snapshot agent and merge
agents should be enough.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

AddThis Social Bookmark Button