Delete Database

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition. We would like to delete a database. Do we just open Enterprise
Manager and delete a database? Do we need to do anything else. Thanks.Yes, it's that easy. Alternatively, you can execute a DROP DATABASE command
from Query Analyzer. In either case, there may be no connections to the
database being dropped.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:%23fZ3pKp0FHA.3720@.TK2MSFTNGP14.phx.gbl...
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition. We would like to delete a database. Do we just open Enterprise
> Manager and delete a database? Do we need to do anything else. Thanks.
>|||Thank you very much, Dan.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:%23B%23qXdr0FHA.2932@.TK2MSFTNGP10.phx.gbl...
> Yes, it's that easy. Alternatively, you can execute a DROP DATABASE
command
> from Query Analyzer. In either case, there may be no connections to the
> database being dropped.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:%23fZ3pKp0FHA.3720@.TK2MSFTNGP14.phx.gbl...
> > We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> > Edition. We would like to delete a database. Do we just open
Enterprise
> > Manager and delete a database? Do we need to do anything else. Thanks.
> >
> >
>|||Hi,
Before drop Please take a backup and keep it in some archive folde incase if
you have some data inside the database .
Thanks
Hari
SQL Server MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ejCVDFs0FHA.2064@.TK2MSFTNGP09.phx.gbl...
> Thank you very much, Dan.
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23B%23qXdr0FHA.2932@.TK2MSFTNGP10.phx.gbl...
>> Yes, it's that easy. Alternatively, you can execute a DROP DATABASE
> command
>> from Query Analyzer. In either case, there may be no connections to the
>> database being dropped.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Diane Walker" <ett9300@.yahoo.com> wrote in message
>> news:%23fZ3pKp0FHA.3720@.TK2MSFTNGP14.phx.gbl...
>> > We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
>> > Edition. We would like to delete a database. Do we just open
> Enterprise
>> > Manager and delete a database? Do we need to do anything else.
>> > Thanks.
>> >
>> >
>>
>|||Thanks.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OtSToss0FHA.3856@.tk2msftngp13.phx.gbl...
> Hi,
> Before drop Please take a backup and keep it in some archive folde incase
> if you have some data inside the database .
> Thanks
> Hari
> SQL Server MVP
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ejCVDFs0FHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Thank you very much, Dan.
>> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
>> news:%23B%23qXdr0FHA.2932@.TK2MSFTNGP10.phx.gbl...
>> Yes, it's that easy. Alternatively, you can execute a DROP DATABASE
>> command
>> from Query Analyzer. In either case, there may be no connections to the
>> database being dropped.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Diane Walker" <ett9300@.yahoo.com> wrote in message
>> news:%23fZ3pKp0FHA.3720@.TK2MSFTNGP14.phx.gbl...
>> > We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
>> > Edition. We would like to delete a database. Do we just open
>> Enterprise
>> > Manager and delete a database? Do we need to do anything else.
>> > Thanks.
>> >
>> >
>>
>>
>