Cannot add articles to an existing publication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sas - 30 Mar 2006 21:35 GMT

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.

Signature

--
"I saw it work in a cartoon once so I am pretty sure I can do it."

Reply to this Message

Hilary Cotter - 30 Mar 2006 22:32 GMT

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

Signature

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

> Hi everyone,
>
[quoted text clipped - 9 lines]
>
> Your input would be appreciated.

Reply to this Message