Replication Question

I have continuous transactional replication running from a production server
to a reporting server. Both servers are SQL 2000. A week or so ago, a new
column was added to a table being replicated (on both production and
reporting servers). I need to get that field included in the replication.
Can this be done without having to drop the subscription, adding the field,
re-create the subscription and then re-creating a snapshot?
--
Message posted via http://www.sqlmonster.com"cynault via SQLMonster.com" <u7602@.uwe> wrote in message
news:61851d6b86210@.uwe...
> I have continuous transactional replication running from a production
server
> to a reporting server. Both servers are SQL 2000. A week or so ago, a
new
> column was added to a table being replicated (on both production and
> reporting servers). I need to get that field included in the replication.
> Can this be done without having to drop the subscription, adding the
field,
> re-create the subscription and then re-creating a snapshot?
>
Not if the column has already been added.
But look up sp_repladdcolumn for future reference.
> --
> Message posted via http://www.sqlmonster.com|||Thank you!
--
Message posted via http://www.sqlmonster.comsql