Unable to modify tables after merge replication is

  • 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

  • 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.


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

    Good Luck

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply