title: SQL Server generating error during merge replication on a table which has been deleted
body: <p>I added a table tblJoinCustBlastList to a merge replicated database and now I'm getting this failure error during replication:</p>
  
  <p>Error messages: </p>
  
  <blockquote>
    <p>The schema script 'if object_id(N'[dbo].[tblJoinCustBlastlist]') is not null exec('ALTER TABLE [dbo].[tblJoinCustBlastlist] ADD CONSTRAINT PK_tblJoinCustBlastlist PRIMARY KEY CLUSTERED ( JoinID ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]</p>
    
    <p>')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) Get help: <a href="http://help/MSSQL_REPL-2147201001" rel="nofollow noreferrer">http://help/MSSQL_REPL-2147201001</a> Table 'tblJoinCustBlastlist' already has a primary key defined on it. (Source: MSSQLServer, Error number: 1779) Get help: <a href="http://help/1779" rel="nofollow noreferrer">http://help/1779</a> Could not create constraint. See previous errors. (Source: MSSQLServer, Error number: 1750) Get help: <a href="http://help/1750" rel="nofollow noreferrer">http://help/1750</a></p>
  </blockquote>
  
  <p>All of the help links are dead.  The table which caused the replication to fail (rblJoinCustBlastList) only has 3 fields:</p>
  
  <p>JoinID -int- Primary Key - no nulls</p>
  
  <p>fkCustID - int- no nulls </p>
  
  <p>fkBlastListID - int- no nulls</p>
  
  <p>and the system-created field Rowguid - uniqueidentifier</p>
  
  <p>For my own troubleshooting, I removed this table from the articles to be replicated and then I even deleted the entire table from the database.  When I tried to synch again to see if the error cleared out, I got the exact same message!  Why is it giving me an error on a table that's not even supposed to be replicating, and is even deleted?  And how do I fix this?  Please help a newbie, none of my users can synch now...</p>