Editing Replication Registry Entries

The Windows NT Registry key

HKEY_LOCAL_MACHINE
    \SOFTWARE
        \Microsoft
            \MSSQLServer
                \Replication

has two replication values:

• The name of the distribution database
• The working directory for replication

These values are automatically set up by SQL Enterprise Manager¾it should not be necessary to modify them manually. Editing of the Registry is normally not recommended. However, if necessary, these key values can be viewed and modified by using regedt32.

HKEY_LOCAL_MACHINE
    \SOFTWARE
        \Microsoft
            \MSSQLServer
                \Replication

Value 0
    Name: DistributionDB
    Type: REG_SZ
    Data: distribution

Value 1
    Name: WorkingDirectory
    Type: REG_SZ
    Data: \\servername\C$\SQL60\REPLDATA

In the Working Directory data entry, servername is the name of the distribution server. It may be a remote distribution server or the local publisher/distributor.

Note The working directory entry can easily be modified using SQL Enterprise Manager. For information see Chapter 14, Setting Up Replication.