Hi,

I was the same problem and the table sys.sysdatabases, my DB was trasaction, but it not was.

I execute the procedure sp_removedbreplication, change the recovery model to simple, shrink logfile...

Good question.

The software house don't allow yet. They are testing yours T-sql for sql2k5.

Hum...

But wasn´t wasted of time because I had have make a new snapshot, many times...

I believe that if I just droped database and recreated, worked very well, and, why not...

Hi Doctor...

Yesterday, before I see your post, I tried another and last solution. Exactly watch you said. I droped subscribers, take off sql server 7 and put sql server 2000...

And a new day born...

The error message complete.

The process could not deliver the snapshot to the Subscriber.

(Source: Merge Replication Provider (Agent); Error number: -2147201001)

---------------------------------------------------------------------------------------------------------------

Cannot insert duplicate key row in object...

Ok. I did what you say. The same error happened. Yesterday I executed SP4 again. Don't change nothing...

The tables sysmergeschemachange, sysmergepublications, sysarticles and sysmergesubscriptios are working fine. then are same...

Ok. I did what you say. The same error happened. Yesterday I executed SP4 again. Don't change nothing...

The tables sysmergeschemachange, sysmergepublications, sysarticles and sysmergesubscriptios are working fine. then are same...

Doctor,

Execute the procedure sp_removedbreplication 'database'. Look in BOL.

Execute in publisher in the subscriber too.

Hi. Thanks for help.

The microsoft don't desagree to use publisher with sql server 2000 and subscribers 7 or 2000. Then had have the last Service Pack and we had clients...

I really need help...

I think it is dirty database. I did upgrade in distribution and publisher. Sql server 7 to Sql server 2000. I disable all replication e able again...

I fellows,

I had the same problem with sql server 7. Yes, very old.

The MDBS set was suspect. I try all ways, but I fall in the same error. Sort order...

Hi,

I had the same problem with sql server 2000 SP4. Really, dbcc dbreindex is great to erros, and very fast.

Thanks.

4 all,

this problem is a bug.

I generated a new subscriber and droped it. thus the properties make a new data again.

Thanks for all.

Yes, I checked that.  was the first thing I think. But, my id is member the role sa. I saw in other forum that, I need delete the article for...