How to remove SQL datasase from Server Explorer ?

[kianang]

The SQL is MSDE . In Serevr explorer , under Server -\\Mycomputer\SQlserver , there are sevear database shown.
Some of databse I created at previous time . How to remove it ?

When I right click the database , I can only "Discconect" it but the database still remains at the list.

 

[xramaas]

What is your version of Visual Studio?
Some tasks you can't perform without Enterprise Architect.

 

[Craig0201]

Ummmm......

Simple one this.....

Highlight the one you want.....

And ummm.....what's that key.....

Ah....that's the one.....DELETE!!!

Craig

 

[kianang]

The version I used is Visual Studio.NET Enterprise Architect.

When I highlight the databse and pressed "Delete" , there is no response frm VS.NET .

When I right click the databse , I can see the "Disconnect" but no "Delete" option form the list.

 

[FRoeCassNet]

I'm not sure you can in Server Explorer. Just go into ISQLW and execute &quot;DROP DATABASE <db>&quot;... Of if you don't want the data physically deleted, you can execute the sp_detatchdb stored procedure.

 

[chiph]

FRoeCassNet -
I don't think he wants the database dropped -- just the link to it in the Server Explorer.

Chip H.

 

[Zarcom]

Which you can't do since Server Explorer simply lists the SQL databases that are available. If your right in what he wants chip then this is a very non crital cosmetic issue. That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540