Drop a Database

We are running SQL Server 2000 with SP3.
We would like to remove an old database which is not used
anymore.
I intend to do
1) Delete DB in Enterprise Manager
2) Remove Server Login for that particular database in
Enterprise Manager
Is there any step missed ?
ThanksHi,
You can just delete it . also if u don't want amy roles or logins u can
delete it also
--
Shaju Thomas
"Roger Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:037d01c39c3f$10375400$a601280a@.phx.gbl...
> We are running SQL Server 2000 with SP3.
> We would like to remove an old database which is not used
> anymore.
> I intend to do
> 1) Delete DB in Enterprise Manager
> 2) Remove Server Login for that particular database in
> Enterprise Manager
> Is there any step missed ?
> Thanks
>|||Roles are inside the database, no need to delete any roles. (As you can't create any server
roles...)
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Shaju" <answer@.hotmail.com> wrote in message news:uzHpoSEnDHA.3288@.tk2msftngp13.phx.gbl...
> Hi,
> You can just delete it . also if u don't want amy roles or logins u can
> delete it also
> --
> Shaju Thomas
> "Roger Lee" <anonymous@.discussions.microsoft.com> wrote in message
> news:037d01c39c3f$10375400$a601280a@.phx.gbl...
> > We are running SQL Server 2000 with SP3.
> >
> > We would like to remove an old database which is not used
> > anymore.
> >
> > I intend to do
> > 1) Delete DB in Enterprise Manager
> > 2) Remove Server Login for that particular database in
> > Enterprise Manager
> >
> > Is there any step missed ?
> >
> > Thanks
> >
> >
>|||Roger,
watch out DTS packages and jobs referencing the db. They are outside the
db.
Quentin
"Roger Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:037d01c39c3f$10375400$a601280a@.phx.gbl...
> We are running SQL Server 2000 with SP3.
> We would like to remove an old database which is not used
> anymore.
> I intend to do
> 1) Delete DB in Enterprise Manager
> 2) Remove Server Login for that particular database in
> Enterprise Manager
> Is there any step missed ?
> Thanks
>