|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Blank Database Name
Somehow a database got created that has no name...not even a space. If you
look in the diagrams, tables, views, and etc there is nothing there. How can I get rid of this bad db? If I try to delete I get the following: Error 21776: [SQL-DMO] The name '' was not found in the Databases collection.... Thanks! "Mat Powell" <MatPow***@discussions.microsoft.com> wrote in message Run the following query and see if you can find the database information innews:52E877A4-B05C-4DF5-8A80-CFD7368B147C@microsoft.com... > Somehow a database got created that has no name...not even a space. If you > look in the diagrams, tables, views, and etc there is nothing there. How can > I get rid of this bad db? If I try to delete I get the following: > > Error 21776: [SQL-DMO] The name '' was not found in the Databases > collection.... > > > Thanks! the system tables. If you can find it there, then you can probably update the sysdatabases table and give the DB_ID in question a name that you can work with. SELECT * FROM master.dbo.sysdatabases Rick Sawtell MCT, MCSD, MCDBA Rick...thanks for helping out. I was able to find the entry in the table you
specified. I updated the "Name" column, but the db still does not have a name in the Database view. I would just delete the record, but I figured I would check with you first to see what the possible consequences might be. Show quoteHide quote "Rick Sawtell" wrote: > > "Mat Powell" <MatPow***@discussions.microsoft.com> wrote in message > news:52E877A4-B05C-4DF5-8A80-CFD7368B147C@microsoft.com... > > Somehow a database got created that has no name...not even a space. If > you > > look in the diagrams, tables, views, and etc there is nothing there. How > can > > I get rid of this bad db? If I try to delete I get the following: > > > > Error 21776: [SQL-DMO] The name '' was not found in the Databases > > collection.... > > > > > > Thanks! > > Run the following query and see if you can find the database information in > the system tables. > > If you can find it there, then you can probably update the sysdatabases > table and give the DB_ID in question a name that you can work with. > > SELECT * FROM master.dbo.sysdatabases > > > Rick Sawtell > MCT, MCSD, MCDBA > > > > then try sp_rename '', 'New-Name', 'Database'
Show quoteHide quote "Mat Powell" wrote: > Rick...thanks for helping out. I was able to find the entry in the table you > specified. I updated the "Name" column, but the db still does not have a > name in the Database view. I would just delete the record, but I figured I > would check with you first to see what the possible consequences might be. > > "Rick Sawtell" wrote: > > > > > "Mat Powell" <MatPow***@discussions.microsoft.com> wrote in message > > news:52E877A4-B05C-4DF5-8A80-CFD7368B147C@microsoft.com... > > > Somehow a database got created that has no name...not even a space. If > > you > > > look in the diagrams, tables, views, and etc there is nothing there. How > > can > > > I get rid of this bad db? If I try to delete I get the following: > > > > > > Error 21776: [SQL-DMO] The name '' was not found in the Databases > > > collection.... > > > > > > > > > Thanks! > > > > Run the following query and see if you can find the database information in > > the system tables. > > > > If you can find it there, then you can probably update the sysdatabases > > table and give the DB_ID in question a name that you can work with. > > > > SELECT * FROM master.dbo.sysdatabases > > > > > > Rick Sawtell > > MCT, MCSD, MCDBA > > > > > > > > Rick....nevermind, your suggestion did work. I just didn't get it enough
time to refresh. I was able to delete the db using the menus. Thanks again!! Show quoteHide quote "Rick Sawtell" wrote: > > "Mat Powell" <MatPow***@discussions.microsoft.com> wrote in message > news:52E877A4-B05C-4DF5-8A80-CFD7368B147C@microsoft.com... > > Somehow a database got created that has no name...not even a space. If > you > > look in the diagrams, tables, views, and etc there is nothing there. How > can > > I get rid of this bad db? If I try to delete I get the following: > > > > Error 21776: [SQL-DMO] The name '' was not found in the Databases > > collection.... > > > > > > Thanks! > > Run the following query and see if you can find the database information in > the system tables. > > If you can find it there, then you can probably update the sysdatabases > table and give the DB_ID in question a name that you can work with. > > SELECT * FROM master.dbo.sysdatabases > > > Rick Sawtell > MCT, MCSD, MCDBA > > > >  
Other interesting topics
Variable Number of Parameters
how to know if a DEFAULT exists or not Perfmon counters into SQL Server table Why use null values? locking an SQL Server DB with .NET how do I search for duplicate values in normalized data ? Query's in Query Analyzer sometimes extremely slow Q: full backup sqlservr.exe -g ??? SQL Enterprise Manager Question |
|||||||||||||||||||||||
