|
I have taken a backup from replicated database and restore it in another server, but can't edit or delete tables from that database it saying " Cannot add columns to table 'tblMastTestHeader' because it is being published for merge replication "
(comments are locked)
|
|
Backing up and restoring replicated databases in SQL 2000 can be a real headache. We do this once a month and still occasionally come up with issues. Sometimes sp_removedbreplication simply doesn't work, and I have had to drop replication for the entire server and rebuild it (ie turn off publishing and distribution). Frank, you seem to be asking a different question (one about stored procedure) than the first one in this series, so it might be better if you submitted it as a new question instead of trying to piggyback. It will help if you can post the results of the removedbreplication proc, as well as the error you receive when trying to drop the stored procedures.
(comments are locked)
|
|
Have you tried running sp_removedbreplication?
(comments are locked)
|
|
i have the same problem and have use the sp_removedReplication, but the problem i have is that cant drop the SPs and they are marked in sysobjects with 512 in the replinfo field, have anyone and idea how to change this or force the dropping of the sp??
(comments are locked)
|
