Unable to modify tables after merge replication is

• Robert W Marda

  SSChampion

  Points: 13413

  More actions

  January 18, 2002 at 3:04 pm

  #78234

  We have encountered a problem with merge replication in that we have removed it but we can't modify any of our user tables and get the following error:

  'tblAvg' table

  - Unable to modify table.

  ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.tblAvg' because it is published for replication.

  we have executed these sp's:

  exec sp_MSdrop_mergesystables

  execute sp_removedbreplication 'dbBuySide'

  and the problem still exists. Does anyone know how to fix this problem?

  Robert Marda

  Robert W. Marda
  Billing and OSS Specialist - SQL Programmer
  MCL Systems

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  January 18, 2002 at 4:02 pm

  #422320

  I think there is another cleanup proc. Dont have it handy, you might try searching the site for merge replication. Will try to look later.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• terryute

  Mr or Mrs. 500

  Points: 574

  More actions

  April 4, 2002 at 6:26 pm

  #426659

  Check The Replinfo field in sysobjects for the object in question. It should be 0 if the object is not replicated

  Good Luck