Re: Got an Exception error - still
- From: Jay B <jayB@xxxxxxxxxxx>
- Date: Fri, 24 Nov 2006 12:31:52 -0500
it looks to me like you are trying to attach the adventureworks database which is made for sql2005 with sql2000, which probably is not compatible.
if you are running the sql2005 manager, and you got the sql2000 productversion, then you need to register server again and look for the sql2005 instance. then attach your adventureworks database.
Henry Jones wrote:
I uninstalled the AdventureWorks from the the control panel then I downloaded a new copy of the AdventureWorksDB.msi and I also tried AdventureWorksDBCI.msi (Don't know what the difference is) and when the install finished, SQL doesn't see the database, I still get the error message. I tried using Enterprise Manager for SQL 2000. I don't know what the problem is..
Thanks,
Henry
"Arnie Rowland" <arnie@xxxxxxxx> wrote in message news:eNNwo3oDHHA.4280@xxxxxxxxxxxxxxxxxxxxxxxHave you considered that perhaps your copy of the Adventureworks files are corrupt?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the top yourself.
- H. Norman Schwarzkopf
"Henry Jones" <henry@xxxxxxxx> wrote in message news:uHg4HjoDHHA.4312@xxxxxxxxxxxxxxxxxxxxxxxOn the screen to attach the database, the only choice is adding the mdf. Once the mdf is chosen, both the mdf and ldf files appear below in thebox.
I still get the error
"Jay B" <jayB@xxxxxxxxxxx> wrote in message news:rz39h.37$UA5.32@xxxxxxxxxxxxxxxthere are 2 files that make up a database, the mdf and the ldf.
they act as a set.
Henry Jones wrote:I got an error when I tried to attach to the database in the folder that it was installed in.
"Could not find row in sysindex for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database "AdventureWorks". CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
"Jay B" <jayB@xxxxxxxxxxx> wrote in message news:cp09h.26$UA5.8@xxxxxxxxxxxxxxxsimple. databases can be in any folder on your computer.
with that said, simply go to the databases node in the tree, right click and use the ATTACH option, then sepecify the folder where you have the adventureworks. if you want to move it, then move it before attaching.
Henry Jones wrote:I went to Microsoft downloads and downloaded the AdventureWorks.msi file. When it ran, it says that it installed AdventureWorks.
I think I have SQL 2005 Express and SQL 2005 on my PC. There are two directories: C:\Program Files\Microsoft SQL Server\MSSQL\Data
and C:\Program Files\Microsoft SQL Server\MSSQL.1\Data
The AdventureWorks has been placed in the C:\Program Files\Microsoft SQL Server\MSSQL.1\Data directory, but when I bring up SQL Server Management Studio, I don't see AdventureWorks. The databases I have associated with this are all under the C:\Program Files\Microsoft SQL Server\MSSQL\Data directory.
How can I import the table into SQL server and why did the MSI install put it in the wrong place.
Thanks for any guidence and help on this "day before Thanksgiving"
- Follow-Ups:
- Re: Got an Exception error - still
- From: Henry Jones
- Re: Got an Exception error - still
- References:
- Trying to Install AdventureWorks in SQL 2005
- From: Henry Jones
- Re: Trying to Install AdventureWorks in SQL 2005
- From: Jay B
- Got an Exception error
- From: Henry Jones
- Re: Got an Exception error
- From: Jay B
- Re: Got an Exception error - still
- From: Henry Jones
- Re: Got an Exception error - still
- From: Arnie Rowland
- Re: Got an Exception error - still
- From: Henry Jones
- Trying to Install AdventureWorks in SQL 2005
- Prev by Date: Re: Making server setting changes with a windows app
- Next by Date: Re: Got an Exception error - still
- Previous by thread: Re: Got an Exception error - still
- Next by thread: Re: Got an Exception error - still
- Index(es):
Relevant Pages
|
