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 |
|
danielhai
Yak Posting Veteran
50 Posts |
 Posted - 2002-07-10 : 18:03:33
|
| I had a database set up for snapshot replication, but unfortunately, someone went ahead and restored over it - destroying the replication. I tried to create the publication, but it gave me: Error 14005: Could not drop publication. A subscription exists to it.I looked at the subscriber, and there are no subscriptions ... I tried running the sp_dboption on the databases on both servers, but it wasn't liking still.exec sp_dboption 'db','published',falseexec sp_dboption 'db','merge publish',falseexec sp_dboption 'db','subscribed',falsei don't know if the execution was correct, because when i executed sp_dboption, it returned a column with alt_optname with a value of 'published' or 'merge publish' etc.Any help? Thanks ... |
|
|
danielhai
Yak Posting Veteran
50 Posts |
Posted - 2002-07-15 : 17:31:33
|
| i figured it out - there were still a bunch of records in the distribution database, and i had to go in manually to the 4 or 5 tables, and delete the references ...dan |
 |
|
|
|
|
|
|
|
Can't recreate publication?