sql server replication: Hi,

I already have a merge replication setup successfully.

However I now need to change the network from a central publisher to a
central publisher with remote distributor

See http://www.databasejournal.com/features/mssql/article.php/1458491 and
Ctrl+F for the words central publisher.


I tried to redo another publication but the wizard no longer asks me whether
I want my distributor to be on a remote machine.


Then I tried to follow this article
http://technet.microsoft.com/en-us/library/ms151192.aspx

and looked for a Configure distribution which I cannot find.

Then I tried this article
http://msdn2.microsoft.com/en-us/library/ms147363.aspx
, but realise that the value of installed in the result set is 1, so I am
not sure what I should do next. Furthermore I am unfamiliar with the T-SQL
syntax necessary to make the changes.

FYI, the result set from using the sp_get_distribution was
installed = 1
distribution server = machineName
distribution db installed = 1
is distribution publisher = 1
has remote distribution = 0

Please advise. I am running SQL server 2005 Trial edition on 2 separate
win2003 server with one of them already set up as a successful central
publisher.

If I really have no choice but to use T-SQL please give me more explicit

This is pretty much a one-off choice. To move to a remote distributor I'd
script out the publications, remove the subscriptionas and publications,
remove the distributor entirely, readd the distributor remotely then add the
publications again.
HTH,
Paul Ibison