On 2004-12-07, RML51 <mike.lacy@courts.state.mn.us> wrote:
> I have a separate server that is used as the distributor. We have our
> production replication using a db called DistributorProd on this server
> (this was built several weeks ago). I was doing some testing, so I created a
> second db called DistributorTest on this server. After I was done testing, I
> used the Wizard to remove the test replication. For some reason the
> DistributorTest db is still there and I can't delete it. It says that it's
> being used by replication. Any ideas on how to get rid of this? Is it
> possible that my PROD replication is somehow now using both the
> DistributorProd and DistributorTest dbs?
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:225901c4dd21$1d8c4dd0$a301280a@phx.gbl...
> Try
> exec sp_removedbreplication 'dbname'
> go
> exec sp_dboption 'dbname, 'published', 'FALSE'
> go
> exec sp_dboption 'dbname, 'merge publish', 'FALSE'
> go
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:22b001c4dd2e$792ddf20$a301280a@phx.gbl...
> OK - it looks like I misunderstood - perhaps these
> databases are distribution databases? What happend if you
> run sp_helpdistributor - do you get back both rows?
> If this is the right track and you right-click the
> replication monitor and select properties, it sould be
> possible to delete the extra distribution database from
> here.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

"RML51" <mike.lacy@courts.state.mn.us> wrote in message
news:OJqFYDT3EHA.3708@TK2MSFTNGP14.phx.gbl...
> sp_helpdistributor only returns one row.
>
> On the distribution server, when I right-click/properties on the
Replication
> Monitor it only shows the DistributionProd db. The DistributionTest db
that
> I want to delete doesn't appear.
>
> "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
> news:22b001c4dd2e$792ddf20$a301280a@phx.gbl...
> > OK - it looks like I misunderstood - perhaps these
> > databases are distribution databases? What happend if you
> > run sp_helpdistributor - do you get back both rows?
> > If this is the right track and you right-click the
> > replication monitor and select properties, it sould be
> > possible to delete the extra distribution database from
> > here.
> > Rgds,
> > Paul Ibison SQL Server MVP, www.replicationanswers.com
> > (recommended sql server 2000 replication book:
> > http://www.nwsu.com/0974973602p.html)
> >
>
>

"RML51" wrote:

> Well I found this on another forum and it worked.
>
> First, I made a backup of Northwind and restored it to my DistributorTest
> db.
> Then I could delete the DistributionTest db.
>
> "RML51" <mike.lacy@courts.state.mn.us> wrote in message
> news:OJqFYDT3EHA.3708@TK2MSFTNGP14.phx.gbl...
> > sp_helpdistributor only returns one row.
> >
> > On the distribution server, when I right-click/properties on the
> Replication
> > Monitor it only shows the DistributionProd db. The DistributionTest db
> that
> > I want to delete doesn't appear.
> >
> > "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
> > news:22b001c4dd2e$792ddf20$a301280a@phx.gbl...
> > > OK - it looks like I misunderstood - perhaps these
> > > databases are distribution databases? What happend if you
> > > run sp_helpdistributor - do you get back both rows?
> > > If this is the right track and you right-click the
> > > replication monitor and select properties, it sould be
> > > possible to delete the extra distribution database from
> > > here.
> > > Rgds,
> > > Paul Ibison SQL Server MVP, www.replicationanswers.com
> > > (recommended sql server 2000 replication book:
> > > http://www.nwsu.com/0974973602p.html)
> > >
> >
> >
>
>