November 8, 2001 at 8:08 am
From time to time I receive scripts from developers that modify tables within a replicated database.
I would like to know if it is possible to 'exec sp_droparticle' the table(s) to be modified and then 'exec sp_addarticle' back in after the modification is made.
I am attempting to avoid having to drop the entire replication and remake it each time I have to apply DDL to replicated tables.
Any assistance I receive will be much appreciated!!
November 8, 2001 at 5:12 pm
Yes, it is possible. In SQL2k you can add/drop columns without a lot of work. In SQL 7 you have to do it the hard way! See if these articles help any.
http://www.sqlservercentral.com/columnists/awarren/alterreplicatedtable.asp
http://www.sqlservercentral.com/columnists/awarren/alterreplicatedtable2k.asp
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply