Got an Exception error

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: Unable to install 64bit SQL 2005 on Windows 2008 Cluster
    ... cluster installation of SQL. ... All of the database files are on the SAN share. ... Below are the logs from the install. ... SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM ...
    (microsoft.public.sqlserver.clustering)
  • RE: SPS WSS SQL 2000 same machine
    ... that the MSSQL$SHAREPOINT SQL Service instance is not running. ... both are installed on the SQL Server Default instance. ... You MUST install WSS before SPS. ... However, when selecting the Database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Offline application for reporting and collect data
    ... Build one user interface that points to either you SQL Server database (when ... Build custom synchronization routines to deal with 'data exchange / ... to install SQL server and restore the database backup in the system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)
Loading