Hello,

Some hopefully simple questions for the replication experts!

SQL Server 2000, transactional replication, one publisher, one
subscriber.

I have added a column to an article on the publisher and the publisher
is already published.  Initially I tried to do this as follows:

sp_repladdcolumn    @source_object = 'tblA',
        @column = 'NewField',
        @typetext = 'int NULL',
        @publication_to_add = 'MyPublication',
        @force_reinit_subscription = 0

but this gave me an error message:
"Error 21381.  Cannot add (drop) column to table 'tblA' because the
table belongs to publication(s) with an active updatable subscription.
Set @force_reinit_subscription to 1 to force reinitialization"

I then re-ran the above with @force_reinit_subscription=1.  The command
worked and returned the message "subscription(s) reinitliazed" but the
new column hasn't appeared on the subscriber.

My questions are as follows:

1 - Do I have to re-run the Snapshot Agent?
2 - If I do re-run the Snapshot Agent, will it reinitialize all other
tables (and their data) or will it just add the new column?
3 - Is there a way I can view the reinitialization commands that are
queued at the publisher to see whether the queued command is to add the
new column or whether it is to reinitialize everything?

Thanks very much!
Pawel