Hello,

I created a connection to my SQL Server in Visual Studio 2008. How can
I delete a database? I tried:

Drop database MyDb

It didn't work.

Thanks,
Miguel

you can not drop a database in use. close all connections to the database,
then connect to master, then issue command.

-- bruce (sqlwork.com)


"shapper" wrote:

> Hello,
>
> I created a connection to my SQL Server in Visual Studio 2008. How can
> I delete a database? I tried:
>
> Drop database MyDb
>
> It didn't work.
>
> Thanks,
> Miguel
>

1. To use DROP DATABASE, the database context of the connection must be in
the master database
2. You cannot drop a database currently in use (open for reading or writing
by any user).

George.


"shapper" <(E-Mail Removed)> wrote in message
news:4561da23-f866-4bf8-a0d7-(E-Mail Removed)...
> Hello,
>
> I created a connection to my SQL Server in Visual Studio 2008. How can
> I delete a database? I tried:
>
> Drop database MyDb
>
> It didn't work.
>
> Thanks,
> Miguel