This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 78%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZB%3C/text%3E%3C/svg%3E)
Hi,
We have Transaction replication in place working fine with 3 publications on server A , Subscriptions on 2 different servers B & C.
Now we want to add another subscription on server D to same publications but we want selected tables & selected columns from existing publications to new subscriber(D). Is it possible ?
If yes, will it not impact distribution database as it is same for all the subscribers.
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hi @Zahid Butt ,
>Now we want to add another subscription on server D to same publications but we want selected tables & selected columns from existing publications to new subscriber(D). Is it possible ?
No, it's not possible in transactional replication. You need to modify an existing publication or create a new one to contain only specific tables and columns.
Thanks for your time.
Now if I create new publication with selected tables & columns, do I have to create new distributor as well (or already created distribution can be used) ?
Thanks once again.
Hi @Zahid Butt ,
You just need to use the already configured distribution.
Thanks a lot.
You are welcome. Have a nice day!