title: How do I add a second subscriber to SQL 2005 Transactional Replication publication
body: <p>I have setup SQL 2005 Transactional Replication, with one master database acting as the publisher, and one subscriber.  It's running fine.  Now, I want to add a second subscriber to this publication.  I created the subscription on the second server, and created the snapshot ok, but when it starts to syncronize I get the error </p>
  
  <p>"Cannot drop the table 'xxxxx' because it is being used for replication."</p>
  
  <p>How do I add a second subscriber to an existing publication that already has one subscriber?   I don't want to stop the first subscription that already exists and is working fine if possible.</p>