"digger27" <digger27@discussions.microsoft.com> wrote in message
news:914CC09F-1341-427B-A6EC-52C4C6FCC191@microsoft.com...
> My company will soon be upgrading our Access Database to SQL Server 2000.
In
> order to begin testing and programming for the move, I have downloaded and
> installed SQL2K MSDE SP3. My install went smooth and it works fine. The
> problem I am having is when I am creating new databases or upgrading from
> Access databases. If I decide the SQL Database that I created isn't what
I
> am needing then I go to the Data directory for MSDE and delete the
database.
> However, when I use Access to create another database by upsizing it sees
> that the previous databases are still installed, as does the MSDE Manager
> that I downloaded.
>
> Question is, is there something else that I need to be doing to completely
> remove the SQL databases from my system beyond deleting them from the Data
> folder wherer they are initially created?
>
> Thanks in advance.

"Norman Yuan" wrote:

> If you mean remove the database, while keep the server (SQL Server/MSDE),
> then you need detach the database from SQL Server/MSDE first. Then you can
> delete the corresponding *.mdf/*.ldf files.
>
> "digger27" <digger27@discussions.microsoft.com> wrote in message
> news:914CC09F-1341-427B-A6EC-52C4C6FCC191@microsoft.com...
> > My company will soon be upgrading our Access Database to SQL Server 2000.
> In
> > order to begin testing and programming for the move, I have downloaded and
> > installed SQL2K MSDE SP3. My install went smooth and it works fine. The
> > problem I am having is when I am creating new databases or upgrading from
> > Access databases. If I decide the SQL Database that I created isn't what
> I
> > am needing then I go to the Data directory for MSDE and delete the
> database.
> > However, when I use Access to create another database by upsizing it sees
> > that the previous databases are still installed, as does the MSDE Manager
> > that I downloaded.
> >
> > Question is, is there something else that I need to be doing to completely
> > remove the SQL databases from my system beyond deleting them from the Data
> > folder wherer they are initially created?
> >
> > Thanks in advance.
>
>