hi,
i don't know how, but i got a database with no name, it's just a space. now i can't drop the database, i'm getting a error 21776. how can i delete a database with no name.
please help.
Printable View
hi,
i don't know how, but i got a database with no name, it's just a space. now i can't drop the database, i'm getting a error 21776. how can i delete a database with no name.
please help.
Quote:
Originally Posted by saif016
anyone?????
What do you get with sp_helpdb? Tried rename it with sp_renamedb?
dear sir, i couldn't even select the database with query analyzer, how can i write code with it.....Quote:
Originally Posted by rmiao
is there any sp command to delete a db without mention it's name??
i've solved the problem, just use this command:
drop database [ ]
why the hell u professional couldn't find this answer, i don't know!!!
So it has name with blank. Why the hell you name the db blank? I don't know!!!
saif016
You are not paying anyone to get an answer so keep your attitude with yourself. It is a professional forum so act like one.
rmiao pointed you in the right direction, you do not have to be in the context of blank database to run it.
hey, why so hostile?? i was just surprised that no one give me this simple solution, thats all. did u see that if u just press space on database creation it create a database with a blank name. why is that option enable. it's a god damn bad option for new kidz like me.....
If you want to complain of that, ask Microsoft. This is wrong place.
so grow up and learn to be respectful.Quote:
it's a god damn bad option for new kidz like me
Quote:
why the hell u professional couldn't find this answer, i don't know!!!
It's pretty obvious you were really proud of yourself for finding the solution yourself and you wanted to brag about it. Well clap clap for you, noob. News flash: you're supposed to find solutions yourself. So like skhanal said, grow up and drop the attitude.Quote:
hey, why so hostile??
Show result for
select * from master..sysdatabases