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
Jagminder
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,
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

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

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

Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Acces

Hi,
When I run Microsoft SQL Server Enterprise Manager and click on the
Properties of the SQL Server Registration, I get this error. Error 0: Cannot
load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Access
is denied.). The SQL Server has the latest service pack SP3a. How can I
solve this problem? I used Google but didn't found a solution. Thanks in
advance.
Kind regards,
Sven Aeyels.Sven,
1. Does the SQLServer account has relevant privilege on the /Binn folder
where most of the DLLs reside?
2.Any more info in the event viewer?
3.Did you install any software after SQLServer which might have messed up
the DLLs? Even otherwise try to Run Component Checker tool to check any
discrepancies in the MDAC.More info:
'INFO: Component Checker: Diagnose Problems and Reconfigure MDAC
Installations'
http://support.microsoft.com/?id=307255
4.See if a MDAC reinstall solves the issue.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Sven Aeyels" <sven_aeyels@.hotmail.com> wrote in message
news:eJBfsqgSEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Hi,
> When I run Microsoft SQL Server Enterprise Manager and click on the
> Properties of the SQL Server Registration, I get this error. Error 0:
Cannot
> load the DLL xpstar.dll, or one of the DLLs it references. Reason:
5(Access
> is denied.). The SQL Server has the latest service pack SP3a. How can I
> solve this problem? I used Google but didn't found a solution. Thanks in
> advance.
> Kind regards,
> Sven Aeyels.
>|||Hi,
Thanks for the info. I reinstalled the MDAC and the problem is gone.
I think the problem started when I installed the Security Update for
Microsoft Data Access Components (KB832483). Are there any known issues with
this update? Thanks in advance.
Kind Regards,
Sven Aeyels.
"Sven Aeyels" <sven_aeyels@.hotmail.com> wrote in message
news:eJBfsqgSEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Hi,
> When I run Microsoft SQL Server Enterprise Manager and click on the
> Properties of the SQL Server Registration, I get this error. Error 0:
Cannot
> load the DLL xpstar.dll, or one of the DLLs it references. Reason:
5(Access
> is denied.). The SQL Server has the latest service pack SP3a. How can I
> solve this problem? I used Google but didn't found a solution. Thanks in
> advance.
> Kind regards,
> Sven Aeyels.
>