MSDE query

I use a database product that utilises MSDE 2000. The database creates a
second database called " databasename_data_1.mdf" database when installed.
I noticed after detaching and moving the database that this secondary
database had not attached correctly. However when I tried to reattach it
using the
exec sp_attach_db command it stated that the "databasename_data_1" already
existed. However when I tried to reattach it using the sp_detach_db command
the error message stated it not exist'
If any one has any ideas'
Peter"Peter M" <PeterM@.discussions.microsoft.com> wrote in message
news:C2B01189-C78A-4738-A932-18837A63EC16@.microsoft.com...
> I use a database product that utilises MSDE 2000. The database creates a
> second database called " databasename_data_1.mdf" database when
installed.
> I noticed after detaching and moving the database that this secondary
> database had not attached correctly. However when I tried to reattach it
> using the
> exec sp_attach_db command it stated that the "databasename_data_1" already
> existed. However when I tried to reattach it using the sp_detach_db
command
> the error message stated it not exist'
> If any one has any ideas'
> Peter
What does SELECT * FROM sysdatabases tell you?
Rick Sawtell
MCT, MCSD, MCDBA|||Rick, I will check when back onsite. Do you know much about this
*_data_1.mdf structure. I was not sure if it made a difference when
detaching and reattaching whether one had to be done before the other.
regards
Peter
"Rick Sawtell" wrote:

> "Peter M" <PeterM@.discussions.microsoft.com> wrote in message
> news:C2B01189-C78A-4738-A932-18837A63EC16@.microsoft.com...
> installed.
> command
>
> What does SELECT * FROM sysdatabases tell you?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>