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)
>
>

Error 21776:[SQL-DMO] The name 'databasename' was not found

I'm trying to delete a database but I get the error message
Error 21776:[SQL-DMO] The name 'databasename' was not found in the Databases
collection. How can I resolve this?
Any help appreciated.Is it possible that the owner of the DB no longer exists? If so, then rename
it then drop it.
--
Thomas
"Joe" wrote:
> I'm trying to delete a database but I get the error message
> Error 21776:[SQL-DMO] The name 'databasename' was not found in the Databases
> collection. How can I resolve this?
> Any help appreciated.|||I'm not sure why you are getting the error, unless the database collection
in the GUI needs to be refreshed. You might try deleting the database using
Query Analyzer:
DROP DATABASE MyDatabase
If the database name has some strangeness to it, like blank characters,
enclose the name in brackets:
DROP DATABASE [MyDatabase ]
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:AF2A87F9-70C3-4E35-BE3E-7F5953AF2D49@.microsoft.com...
> I'm trying to delete a database but I get the error message
> Error 21776:[SQL-DMO] The name 'databasename' was not found in the
> Databases
> collection. How can I resolve this?
> Any help appreciated.

Error 21776:[SQL-DMO] The name 'databasename' was not found

I'm trying to delete a database but I get the error message
Error 21776:[SQL-DMO] The name 'databasename' was not found in the Databases
collection. How can I resolve this?
Any help appreciated.
Is it possible that the owner of the DB no longer exists? If so, then rename
it then drop it.
Thomas
"Joe" wrote:

> I'm trying to delete a database but I get the error message
> Error 21776:[SQL-DMO] The name 'databasename' was not found in the Databases
> collection. How can I resolve this?
> Any help appreciated.
|||I'm not sure why you are getting the error, unless the database collection
in the GUI needs to be refreshed. You might try deleting the database using
Query Analyzer:
DROP DATABASE MyDatabase
If the database name has some strangeness to it, like blank characters,
enclose the name in brackets:
DROP DATABASE [MyDatabase ]
Hope this helps.
Dan Guzman
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:AF2A87F9-70C3-4E35-BE3E-7F5953AF2D49@.microsoft.com...
> I'm trying to delete a database but I get the error message
> Error 21776:[SQL-DMO] The name 'databasename' was not found in the
> Databases
> collection. How can I resolve this?
> Any help appreciated.

Error 21776:[SQL-DMO] The name 'databasename' was not found

I'm trying to delete a database but I get the error message
Error 21776:[SQL-DMO] The name 'databasename' was not found in the Datab
ases
collection. How can I resolve this?
Any help appreciated.Is it possible that the owner of the DB no longer exists? If so, then rename
it then drop it.
--
Thomas
"Joe" wrote:

> I'm trying to delete a database but I get the error message
> Error 21776:[SQL-DMO] The name 'databasename' was not found in the Dat
abases
> collection. How can I resolve this?
> Any help appreciated.|||I'm not sure why you are getting the error, unless the database collection
in the GUI needs to be refreshed. You might try deleting the database using
Query Analyzer:
DROP DATABASE MyDatabase
If the database name has some strangeness to it, like blank characters,
enclose the name in brackets:
DROP DATABASE [MyDatabase ]
Hope this helps.
Dan Guzman
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:AF2A87F9-70C3-4E35-BE3E-7F5953AF2D49@.microsoft.com...
> I'm trying to delete a database but I get the error message
> Error 21776:[SQL-DMO] The name 'databasename' was not found in the
> Databases
> collection. How can I resolve this?
> Any help appreciated.