Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
panthagani
Yak Posting Veteran
58 Posts |
 Posted - 2008-10-14 : 07:23:16
|
| I needed to cleanup replication on a test server manually. As part of this, I needed to delete distributor database manually. Since it was throwing up an error, I read in an article to set the sysdatabases category bit to 0 for distributor db. (it was 16 earlier, I think). Once I did this, I was able to delete the distributor. Now, I have a different problem.When I go to Tools --> Replication --> Configure Publishing wizard in Enterprise manager, I get this error:Error 21769: SQL-DMO: The passed ordinal is out of range of the specified collection.I'm planning to cleanup replication completely and set it up from scratch. Here is what I did.I created a new database with the same name as the old distribution database (tlDistributor). Now, I no longer get the above error when I try to configure replication through the wizard. Now, when I go to Tools --> Replication --> Configure Publishing wizard: In the last tab, 'Subscribers', I get the below error;Error 2812: Could not find the stored procedure 'tlDistributor.dbo.sp_MShelp_sbscriber_info'This means that since 'Distribution' is not set up, the 'tlDistributor' database that I created does not contain any replication related stored procedures or tables. So, it is actually a dummy database with the same name. If I delete 'tlDistributor' I get 'Error 21769'. If I create 'tlDistributor' as a new database, it will be a dummy one without the actual content.My goal is to setup transactional replication with one publisher and two subscribers.I think I did something fatally wrong when I set the sysdatabases category bit to 0 (for tlDistributor) and deleted it.Please suggest how I can solve this problem. Thank you. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 09:36:47
|
| You could have used Disable distributor and pub wizard for it? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 09:38:19
|
| I am not sure you are same person here but please see this:http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3998283&SiteID=17 |
|
|
|
panthagani
Yak Posting Veteran
58 Posts |
Posted - 2008-10-14 : 13:19:30
|
| Yes, that was my post in the MSDN forms.Thank you for your inputs. I tried it earlier but since distributor DB is not configured (it just exists as a new database with the same name as earlier, though), I get this error in the last step of the wizard.Error 2812: Could not find stored procedure sp_MSDrop_subscriber_info. Could not create Subscriber. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 14:30:19
|
| Use sp_scriptpublicationcustomprocs to create the script and run it in subscriber. |
|
|
|
|
|
|
|
|
Errors after manually deleting Dist database