sql server replication: Is there any way to just find the new article added? -- sql server replication

Is there any way to just find the new article added?

SBR
10/29/2007 6:40:03 AM

sql server replication:

Hi,

I'm adding a new table into a DB which is published already.
At present I'm looping through all the tables and finding it whether the
table has added for publication, and if not enable it for publishing.

But the number of article size is large. So it leads to a performance issue.

Is there any way to find out new tables, new columns, new SPs added after
the dB got published?

Thanks in advance for the help.

Re: Is there any way to just find the new article added?

Hilary Cotter
10/31/2007 10:27:48 PM

Can you just do an existence check against sysarticles?

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]