?
Solved

Error 20736 while setting up merge replication in SQL Server 2000

Posted on 2008-10-30
4
Medium Priority
?
412 Views
Last Modified: 2012-08-13
I'm trying to setup a merge replication for a database (name is eeq_ann)  in SQL Server 2000.

I got the problem before so I tried a clean install and I still have the trouble.

I create a distributor for my server without any problem.  Now I try to setup a new publication so I use "new publication" in the Enterprise Manager.

I see my database 'eeq_ann', select the table I want to replicate, etc. then I create the publication.  However, during the publication creation process, there is an error :

SQL Server Enterprise Manager could not create publication 'eeq_ann' from database 'eeq_ann'
Error 20736: [SQL-DMO]This object has been dropped from the server.

After that, if I go to create a new publication, I cannot select my database as the system somehow thinks there is one even thougth I cannot see it in the enterprise manager explorer.  When I go to Tools -> Replication -> Create and Manage Publications, I can see it in the tree view but I cannot delete it.

So I tried to delete it manually using the following :

use eeq_ann
go
exec sp_dropmergepublication @publication=N'eeq_ann'
use master
go
exec sp_replicationdboption @dbName=N'eeq_ann',@optname=N'merge publish',@value=N'false'

it says it removed the publication and I do not see it anymore as a matter of fact.  So I tried to recreate the publication, but now I get the same 20736 error in the publication wizard when I try to select a table to merge.

Thanks for the help!
0
Comment
Question by:Francois_Tremblay
  • 3
4 Comments
 
LVL 15

Accepted Solution

by:
MohammedU earned 1500 total points
ID: 22846724
Did you try creating with script...if not...
Try the following...

 
 exec sp_adddistributiondb @database = 'distribution', @data_folder =
N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data', @data_file =
N'distribution.MDF', @data_file_size = 7, @log_folder = N'C:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data', @log_file =
N'distribution.LDF', @log_file_size = 8, @min_distretention = 0,
@max_distretention = 72, @history_retention = 48, @security_mode = 1
GO

-- Adding the distribution publishers
exec sp_adddistpublisher @publisher = @@servername, @distribution_db =
N'distribution', @security_mode = 0, @login = N'sa', @password = N'',
@working_directory = N'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\ReplData', @trusted = N'false', @thirdparty_flag = 0,
@publisher_type = N'MSSQLSERVER'
GO
0
 

Author Comment

by:Francois_Tremblay
ID: 22849363
I think I found the problem.  

When I created my table, I created it using a DTS from the table on the old computer we are replacing.  I copied everything, then I removed the rowguid column created by the replication settings.  However, I did not remove the data.  When I remove the data the replication is created successfully.

I will try later today to see if everything works, I just created it right now.
0
 

Author Comment

by:Francois_Tremblay
ID: 22850883
I found out that when I start from a restore of the database I have lots of trouble creating the replication.

So right now I instead create an empty database and use the script generated by the enterprise manager to output all tables information directly in that empty database.

Now it works.
0
 

Author Closing Comment

by:Francois_Tremblay
ID: 31511841
Did not solve the problem but put me on the path.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question