title: Change the Transactional Replication Distributor on SQL 2000
body: <p>I have a server with about 3 replications configured.</p>
  
  <ul>
  <li>3 databases being published to about 3 other servers </li>
  <li>there's a central Distributor</li>
  </ul>
  
  <p>I need to know if I can change the distributor for one of the publishings and let the others or if I can only change all of the replication distributors at the publisher server.</p>
  
  <p>And How to do this.</p>
  
  <p>Example:</p>
  
  <p><strong>ProdServer</strong> has</p>
  
  <ul>
  <li>DB1 - Publishing</li>
  <li>DB2 - Publishing</li>
  <li>DB3 - Publishing</li>
  </ul>
  
  <p><strong>DB1ReplSrv</strong> has</p>
  
  <ul>
  <li>DB1 - Subscribing</li>
  </ul>
  
  <p><strong>DB2ReplSrv</strong> has</p>
  
  <ul>
  <li>DB2 - Subscribing</li>
  </ul>
  
  <p><strong>DB3ReplSrv</strong> has</p>
  
  <ul>
  <li>DB3 - Subscribing</li>
  </ul>
  
  <p><strong>RplDistSrv</strong> is the distributor for all of this.</p>
  
  <p>Let's say I create a new server:
  <strong>NewRplDistSrv</strong> I wan't slowly change the replications distributor server.</p>
  
  <p>PS:I don't know if it's a Pull or Push Replication, how do I check this?</p>
  
  <p>Sorry for my noobish question. But I would like to learn.</p>
  
  <p>Thanks in advance,</p>
  
  <p>Gabriel</p>