I have set up Transactional Replication ONLY from database A in server 1 (Publisher) to Database B in server 2 (Subscriber). I didnt set up snapshot replication but the database B was restored after taking backup of database A. Replication is
fine now. But, I need to drop one column which is a primary key in one table(foreign key in another table :)) in Publisher without causing any issues to the replication. BTW, I am using SQL SERVER 2008 R2. Can someone please tell me how to do this?
View Complete Post