I've encountered a problem when I re-setup the transaction replication. I want to change the distribution DB to another server. But somehow it always link to the old distribution DB server.
My checking query is the below script, it always return the data in the old distributor db instead of the new one.
select * from distribution..MSsubscriptions where publisher_db='...'
select * from distribution..MSpublications where publisher_db='...'
I even deleted the old link server in the publisher server but still not working. I don't understand where stored the old distribution server name in the publisher. I guess I haven't totally cleaned the old replication possible or the old distribution db store in the cache?