This weekend we had an application upgrade which changed one replicated table structure.

before the upgrade, I used the following to drop the article fom the
subscription:

Code:
Exec dbo.sp_dropsubscription  @publication='My Publication', @article='My table' , @subscriber='My Subscriber'

Exec dbo.sp_droparticle @publication='My Publication', @article='My Table',
@force_invalidate_snapshot=1

Exec dbo.sp_refreshsubscriptions  'My Publication'
Then I stopped replication (turned off the log reader)

After the upgrade ....

I scripted out the new table in the publishing database and dropped and recreated it with the new table structure on the subscribing database. I then dropped the primary key on newly created table in the subscribing database, added the article back in to the publication using ENT Manager and turned back on replication. no luck.

I tried this:
Code:
Exec dbo.sp_dropsubscription  @publication='TowerDB to KOCSQL03', @article='COD' , @subscriber='KOCSQL03'

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

Exec dbo.sp_refreshsubscriptions  'TowerDB to KOCSQL03'
--
Exec dbo.sp_addsubscription  @publication='TowerDB to KOCSQL03', @article='Tower.COD' , @subscriber='KOCSQL03'

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'
Still not working.. don't know what I'm doing wrong???????????????