Dropping/adding articles from a publication

[shweta]

Hello,

I had to make a schema change to one of the articles in a publication. The schema change was changing the datatype of a column from varchar to int. I dropped the article and made the datatype change on the publisher and subscriber, and then re-added the article in.

I also changed the datatype in the insert and update stored procedures for the article.

The problem now is that even though replication is up and running on the server, the article is not replicating over.

Any idea why?

Thanks,
Shweta

 

[donutman]

It's been a long time since I used replication, but I'm willing to hazard a guess. As I recall, the tables have to be synchronized before replication can continue. Doesn't that require another step?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]