January 18, 2002 at 3:04 pm
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
January 18, 2002 at 4:02 pm
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
April 4, 2002 at 6:26 pm
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