Error 1038: Cannot use empty object or coymn names.Use a single sp

hi,
in SQL server, when list down the databases, there is a database without any
name.
also, when i click on the properties option of any other databases, i get
the following error : "Error 1038: Cannot use empty object or coymn names.
Use a single space if necessary".
I am not able to delete the unnamed database.
can any body suggest what to do in this case.
thanks and Regards
Jagminderjust try this in the Query Analyser
sp_renamedb '', 'new_name'
drop database new_name
please let me know, if it worked.
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Jagminder Chugh" wrote:

> hi,
> in SQL server, when list down the databases, there is a database without a
ny
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder|||Hi,
Try issuing the below command:-
DROP DATABASE []
or
DROP DATABASE [ ]
Thanks
Hari
SQL Server MVP
"Jagminder Chugh" <JagminderChugh@.discussions.microsoft.com> wrote in
message news:AB972FBE-58DF-4473-8807-497DB9F7A45B@.microsoft.com...
> hi,
> in SQL server, when list down the databases, there is a database without
> any
> name.
> also, when i click on the properties option of any other databases, i get
> the following error : "Error 1038: Cannot use empty object or coymn names.
> Use a single space if necessary".
> I am not able to delete the unnamed database.
> can any body suggest what to do in this case.
> thanks and Regards
> Jagminder