I have a little problem...
I have this case:
2 server instances
1 Table (5 columns)
From server 1 I created publication to replicate all columns of tables I have in DB1.
From server 2 I created subscription to pull all columns from tables which is in DB1.
But now, I need to publish a column of the same table from server 2 to server 1 and also it has to be in same DB...
I tried with using logic and creating publication for server 2 and subscription on server 1 but there is error appearing:
You have selected the Publisher as a Subscriber and entered a subscription database that is the same as the publishing database. Select another subscription database.
I need it to be A to B and B to A replication
I hope someone understood my problem and have an answer for me.
p.s. Ask for more info if you need ...