Groups | Blog | Home
all groups > sql server replication > january 2005 >

sql server replication : Merge Replication Working Directory



Paul Ibison
1/31/2005 8:51:51 AM
Run sp_helpdistributor and have a look at the 'directory'
value returned.

The following procedure can be used to change it
afterwards:

sp_changedistpublisher @publisher = 'your_publisher'
, @property = 'working_directory'
, @value = 'your_path eg \\DH999\REPLDATA'

Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Shane Lim
1/31/2005 9:22:31 AM
When I create a publishe and distributor and I set the snapshot
location to a network accessible drive for the subscribers to be able
to access. I get errors stating that the script was unable to run and
states a different directory than the snapshot directory. Where to I
set these directories at? Or what stored procedure do I set these at
if I am doing it manually? I am guessing this has to do with the
distributor instead of the publisher?

Thanks

Shane
AddThis Social Bookmark Button