Re: Got an Exception error - still

On 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@xxxxxxxxxxxxxxx
there 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@xxxxxxxxxxxxxxx
simple. 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"





.

Relevant Pages

  • Re: Got an Exception error - still
    ... it looks to me like you are trying to attach the adventureworks database which is made for sql2005 with sql2000, ... I tried using Enterprise Manager for SQL 2000. ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL 2005 SP1 Database Mirroring
    ... Die Dienste SQL Server, SQL Server Agent und SQL Server Browser werden mit ... ALTER DATABASE [AdventureWorks] SET RECOVERY FULL WITH NO_WAIT ...
    (microsoft.public.de.sqlserver)
  • Re: connection between sql files and .Net
    ... Before connecting it from the application attach the database (MDF and LDF) ... Attach the MDF and LDF files to SQL server using a database name, ...
    (microsoft.public.sqlserver.server)
  • Re: Got an Exception error - still
    ... Error 602 can certainly indicate database corruption, ... you're connected to an instance of SQL Server 2000. ... "AdventureWorks". ...
    (microsoft.public.sqlserver.setup)
  • Re: Got an Exception error - still
    ... I uninstalled the AdventureWorks from the the control panel then I ... I tried using Enterprise Manager for SQL 2000. ... Could not open new database ... install put it in the wrong place. ...
    (microsoft.public.sqlserver.setup)