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 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|||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|||hi
thanks for your reply
i tried it but did not work...its giving the same error.
can you suggest some other alternative
Jagminder
"Chandra" wrote:
> just 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 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|||hi
i tried
dropdatabase [ ] and it worked.
thanks for the reply
regards
Jagminder Chugh
IT Consultant
"Chandra" wrote:
> just 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 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