Cannot add articles to an existing publication -- sql server replication

Sas
3/30/2006 12:35:02 PM

Hi everyone,

I have a problem with one of my publishers. When I click on the "Articles"
tab under the "Publication Properties", I see all my articles but everything
is greyed out. I can't uncheck any of the articles and I cannot add any. I
need to add one more article to the publication!

I need to mentioned that the publisher is a SQL 7 and the distributor and
subscriber are on SQL 2K. Up to now everything is working fine but i can't
modify anything...

Your input would be appreciated.

--
--

Hilary Cotter
3/30/2006 4:32:02 PM

Can you drop the subscription , use sp_addarticle, and then redeploy the
subscriber?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]

sql server replication : Cannot add articles to an existing publication