1)WHen I execute the below SP on publisher. I get the below info, How could I Updated distribution server column with server name instead of Linkedserver_Name, that row below?
sp_get_distributor:
installed |distribution server |distribution db installed |is distribution publisher| has remote distribution publisher
0 Linkedserver_Name 0 0 0
2) I am confused, Does the publisher is thinking it as an distributor is configured for linked server.
3) How could I Update the SELECT * FROM Master.sysservers
for datasource coulun.