Does anybody know if I can remove a replication instance, and then remove a couple of tables from the database, and then re-ceate the replication instance to sync the data back between the publisher and subscriber? To make a long story short, one of our database admin folks modified one of the db_cra replication instance to include more tables, in doing this it created a new row and has caused us to not be able to update resource records. We cannot just remove the newly created row as the replication process has it locked. I just want to make sure that if we remove the replication and clean up the database by removing the unnecessary rows if CRS would be affected. If anyone has any experience with this and would be willing to share some pointers I am more than willing to listen. Thanks
I have this problem too.