How can I install the
AdventureWorks 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.
