ERROR 21776, pls help

[saif016]

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.

[saif016]

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.

anyone?????

[rmiao]

What do you get with sp_helpdb? Tried rename it with sp_renamedb?

[saif016]

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.....

is there any sp command to delete a db without mention it's name??

[saif016]

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!!!

[rmiao]

So it has name with blank. Why the hell you name the db blank? I don't know!!!

[skhanal]

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.

[saif016]

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.....

[rmiao]

If you want to complain of that, ask Microsoft. This is wrong place.

[skhanal]

it's a god damn bad option for new kidz like me

so grow up and learn to be respectful.

[nosepicker]

why the hell u professional couldn't find this answer, i don't know!!!

hey, why so hostile??

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.

[Belov Vladimir]

Show result for

select * from master..sysdatabases