SQL 2000 Replication

[jpotucek]

MS SQL server 2000 sp4

Added one article to replication a couple of weeks ago and just realized that it's no replicating.

when I do a

sp_helpsubscription @publication = 'MY publication'

I see the article.. but it's not replicating. did a new snapshot and that didn't work.

doing transactional replication. log reader is running all the time and the distribution agent runs once evey 15 mins.. can anyone help?????

 

[jpotucek]

Can someone tell me the proper steps to remove this article from the publication and add it back in?

 

[jpotucek]

table exists on the subscriber DB but with zero rows..
table exists on the publisher with the correct primary key for replication...

I tried this..

Exec dbo.sp_droparticle @publication='TowerDB to KOCSQL03', @article='tower.COD',
@force_invalidate_snapshot=1
Exec dbo.sp_refreshsubscriptions 'TowerDB to KOCSQL03'

then

Exec dbo.sp_addarticle @publication='TowerDB to KOCSQL03', @article='tower.COD', @source_table= 'tower.cod' , @destination_table= 'tower.cod' ,
@force_invalidate_snapshot=1

Exec dbo.sp_refreshsubscriptions 'TowerDB to KOCSQL03'
Then did a snapshot and REPL Distribution...

TABLE still not replicating??????

when I do
sp_helpsubscription @publication = 'Towerdb to kocsql03'

I DO NOT see my new table.. what the heck am I doing wrong????????