November 30, 2013 at 11:36 am
Hello SQL Guru's,
Im trying to make a replication with a exist table.
When I make a replication its always drops the table and make een new one... But I dont like it I just need only the column to be updated...
How can i fix it.
In the picture I need the column's Date_logged1 and date_logged2 in my table... But when I start my replication its dropping theys columns in table incident.
Picture 1 Original;
Picture 2 when I use a replication;
December 1, 2013 at 10:58 pm
NO answers??!!
December 2, 2013 at 2:48 am
I think the reason you have no replies is you aren't completely clear.
Replication does not drop tables on the publisher.
The default on the subscriptions is to "drop existing" and is a per article setting you can change.
What are you trying to achieve? Are you adding columns to a published table?
December 2, 2013 at 3:07 am
Are you using which type of replication?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply