I have multiple applications that will use the same named instance of MSDE. When I try to setup my second application using the MSDE Deployment addin it thinks that MSDE needs to be installed again. According to the flowchart it should bypass this and
just install my appliation. Any suggestions as to why my setup insists in needs to install another instance? My instance name is the same for all applications.
Thanks,
Bill
Bill in one of the previous messages someone from Microsoft mentioned that it is a known bug in the beta version of the toolkit. Hopefully it will be fixed.
goodluck
dev
|||Thanks for the info. Does anyone know when the full release will be out?
sql
Showing posts with label second. Show all posts
Showing posts with label second. Show all posts
Friday, March 30, 2012
Friday, March 23, 2012
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...
> > 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
>
>
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...
> > 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
>
>
Subscribe to:
Posts (Atom)