November 2, 2004 at 3:07 am
Hi,
Ive run into some serious trouble...
I had to make an "clean-up" among my transactions, when done i have no Publications but the Publishers are still there.
I cant remove the transactions under Replication Monitor->Publishers->SERVER,
i end up with an error saying "Error 21776: [SQL-DMO] The name 'transaction_art' was not found in the TransPublications collection"...
When i try to create a new Publications i get an error saying "Error 14005: Could not drop publication. A subscription exists on it."
Is there any way of getting rid of these?
I´ve tried everything i can think of!
Best regards
Robert
November 4, 2004 at 3:10 am
I am just guessing here as I haven't had this problem. But, you could try scripting the delete of the publications and do it step by step to see if you can skip over the problem. To generate a delete script, right click on the replication-publications tab in Enterprise Manager and select 'Generate SQL scripts'. When you do this you are given the option to 'disable or drop the components'. I don't know if this will generate any script in your case, but it is worth a try.
Hope this helps
Peter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply