Recreating Transactional replication

Last Post 26 Sep 2007 08:51 AM by rambuyer. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
PaulMcKibben
New Member
New Member

--
29 Sep 2006 06:52 AM
I have a functioning SQL 2000 transactional replication. If new fields are added to the publishing databases, do I need to drop and recreate the replications?
rambuyer
New Member
New Member

--
26 Sep 2007 08:51 AM
I agree with RM, but would note that sp_repladdcolumn has been deprecated in SQL Server 2005 and you can now add the fields directly, but you should now use sp_articlecolumn to add columns to a publication.

-- Jeff


Acceptable Use Policy
---