Adding column to table
Just wanted to check. Running merge replication on SQL 2000. If I add a
column to a table that is a published article, I assume I just run
sp_repladdcolumn is that correct and is that all I need to do in order for
the laptops to get the change with their next synch? Also, what do I set
the value for @force_reinit_subscription to? Thanks.
David
.
Relevant Pages
- Re: Linked Tables
... Hi David, I think that Colin has an SQL database that uses an ... this newsgroup. ... replicating the back end (which is SQL Server). ... Server heterogenous replication, as it's a SQL Server issue, not ...
(microsoft.public.access.replication) - Re: Replicating very large articles but need to avoid locks from s
... thank you for the response and tip regarding snapshot processing. ... familiar yet with all of SQL 2005's offerings. ... all averse to replication and used SQL 2000 Transactional replication ... The last issue came from the Distributor clean up job. ...
(microsoft.public.sqlserver.replication) - Re: Replicating very large articles but need to avoid locks from s
... snapshot processing will be inadequate to scale (it is not a pretty sight ... familiar yet with all of SQL 2005's offerings. ... all averse to replication and used SQL 2000 Transactional replication ... The last issue came from the Distributor clean up job. ...
(microsoft.public.sqlserver.replication) - Re: clustering enquires
... Another 3rd party option is LifeKeeper Protection Suite for SQL Server from ... The benefits of host based replication from LifeKeeper is that you don't ... In addition, LifeKeeper can support Active/Active clustering, Cascading ...
(microsoft.public.sqlserver.clustering) - Re: Change distribution server
... This is more of a maintenance question regarding replication. ... With all the SQL Agent jobs and replication pieces, ... Remember my scenario has the remote distributor on SQL2000 if that matters. ... Looking for a SQL Server replication book? ...
(microsoft.public.sqlserver.replication) |
|
