Error 3724: Cannot delete the database

You can use sp_dboption for this:
sp_dboption 'databasename', 'published' , 'false'
go
sp_dboption 'databasename', 'merge publish' , 'false'
go
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sp_dboption 'databasename', 'published' , 'false' works fine.
sp_dboption 'databasename', 'merge publish' , 'false' produces the follwing
error:
Error 20029: The Distributor has not been installed correctly. Could not
disable database for publishing.
What can I do ?
Best regards
Axel Lanser
"Paul Ibison" wrote:

> You can use sp_dboption for this:
> sp_dboption 'databasename', 'published' , 'false'
> go
> sp_dboption 'databasename', 'merge publish' , 'false'
> go
> HTH,
> Paul Ibison, SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||You could remove replication entirely, which sounds like
it might need to be done anyway, but if you want to keep
replication set up and just delete the database, you
could edit the sysdatabases table in master and set the
category to zero.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi,
the problem is solved.
Thank you very much
Axel Lanser
"Paul Ibison" wrote:

> You could remove replication entirely, which sounds like
> it might need to be done anyway, but if you want to keep
> replication set up and just delete the database, you
> could edit the sysdatabases table in master and set the
> category to zero.
> HTH,
> Paul Ibison, SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>