Can't get rid of distribution db

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)
Thanks but it didn't work.
I tried running this on the publishing server, but the dbs I used for the
test no longer exist. I had deleted them after I ran the "Disable Publishing
and Distribution Wizard" and when I was through testing.
BTW - it was a Transactional replication test.
I think I need to reset something on the distribution server. I've looked
through BOL, but haven't found anything yet.
"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)
>
|||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)
|||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)
>
|||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...
>