AdventureWorks database question

How can I install theAdventureWorks database on my box where C:\Program Files\Microsoft SQL Server\90\Tools\Samples\ is missing? My SQL 2005 is currently without AdventureWorks OLT. I downloaded the Enterprise trial before uninstalling SQL2005Express. Please help. Thanks.

It looks like the AdventureWorks database can be downloadedhere.

HTH,
Ryan

|||

As I did the following:

exec

sp_attach_db @.dbname=N'AdventureWorks', @.filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @.filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'

Here's what came back:

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.

Msg 602, Level 21, State 50, Line 1

Could not find row in sysindexes for database ID 24, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

What's wrong here?

Any help is greatly appreciated.

|||

Find instawdb.sql and execute it. This will open "SQL server manegament studio. Enter localhost for servername then click connect. On the sql editor toolbar click execute. wait until get the message "database installed succesfully" in the status bar.

|||

When I do that I get the following error messages:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86)

Aug 6 2000 00:57:48

Copyright (c) 1988-2000 Microsoft Corporation

Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

*** Dropping Database

Msg 208, Level 16, State 1, Line 2

Invalid object name 'master.sys.databases'.

*** Creating Database

Msg 208, Level 16, State 1, Line 5

Invalid object name 'master.sys.master_files'.

Msg 102, Level 15, State 6, Line 11

Incorrect syntax near 'CHECKSUM'.

Msg 911, Level 16, State 1, Line 2

Could not locate entry in sysdatabases for database 'AdventureWorksDW'. No entry found with that name. Make sure that the name is entered correctly.

*** Creating DDL Trigger for Database

Msg 170, Level 15, State 1, Line 9

Line 9: Incorrect syntax near 'max'.

Msg 156, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 3

Incorrect syntax near the keyword 'DATABASE'.

Msg 195, Level 15, State 10, Procedure ddlDatabaseTriggerLog, Line 14

'EVENTDATA' is not a recognized function name.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 15

Line 15: Incorrect syntax near '.'.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 16

Line 16: Incorrect syntax near '.'.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 17

Line 17: Incorrect syntax near '.'.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 25

Line 25: Incorrect syntax near 'max'.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 44

Line 44: Incorrect syntax near '.'.

*** Creating Tables

Msg 2714, Level 16, State 6, Line 2

There is already an object named 'AdventureWorksDWBuildVersion' in the database.

Msg 170, Level 15, State 1, Line 80

Line 80: Incorrect syntax near 'max'.

*** Loading Data

Msg 208, Level 16, State 1, Line 6

Invalid object name 'master.sys.master_files'.

Msg 1779, Level 16, State 0, Line 2

Table 'DimAccount' already has a primary key defined on it.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

Msg 1913, Level 16, State 1, Line 2

There is already an index on table 'DimAccount' named 'AK_DimAccount_AccountCodeAlternateKey'.

*** Creating Foreign Key Constraints

Msg 2714, Level 16, State 4, Line 2

There is already an object named 'FK_DimAccount_DimAccount' in the database.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

*** Creating Table Views

Msg 170, Level 15, State 1, Procedure vDMPrep, Line 48

Line 48: Incorrect syntax near ';'.

Msg 170, Level 15, State 1, Procedure vTimeSeries, Line 41

Line 41: Incorrect syntax near ';'.

Msg 170, Level 15, State 1, Procedure vTargetMail, Line 62

Line 62: Incorrect syntax near ';'.

Msg 208, Level 16, State 1, Procedure vAssocSeqOrders, Line 7

Invalid object name 'dbo.vDMPrep'.

Msg 170, Level 15, State 1, Procedure vAssocSeqLineItems, Line 12

Line 12: Incorrect syntax near ';'.

*** Creating Functions

Msg 2714, Level 16, State 5, Procedure udfMinimumDate, Line 15

There is already an object named 'udfMinimumDate' in the database.

*** Disabling DDL Trigger for Database

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'TRIGGER'.

*** Changing File Growth Values for Database

Msg 911, Level 16, State 1, Line 2

Could not locate entry in sysdatabases for database 'AdventureWorksDW'. No entry found with that name. Make sure that the name is entered correctly.

*** Shrinking Database

Msg 2520, Level 16, State 12, Line 2

Could not find database 'AdventureWorksDW'. Check sysdatabases.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

And on that download link none of those will install either, they installation stops with an error.