instawdb.sql runtime errors

Hot Topic

sql server management studio nov ctp
Nested cursor
ADO Connection Pooling Error: "The client was unable to reuse a session with ..."
Tables in reports splitting between multiple pages
AdomdConnection via a UDL file
Certificate limitations in SQL Server 2005
matrix control parent child grouping
REPLACE Oracle function in SQLServer 2000
Upsizing from MSAccess to SQLServer
Whether probably to receive metadata about a status of cubes, by means of SQL inquiry to SQL Server

SQL Server

importing from access error
How to convert SDF to XML?
URGENT! - - Unable to connect to SQL 2005 Server
Installing SQL Server 2005 on Windows XP Pro x64
sum a calculated field - "varying data types"
Instance name contains a dash
CLR DDL Triggers with SqlTrigger Attribute?
SQL Server Express Security?
MDX calculated member - showing null values
Redistribution and setting advanced options

instawdb.sql runtime errors

I just downloaded adventureWorks database related files and ran script in instawdb.sql. It seems the database and tables have been created but some errors have taken place as well.

I am working with Sept 2005 CTP SQL Server.

*** Creating Data Types -- FINE
*** Creating Pre-Table Database Functions -- FINE
*** Creating Database Schemas -- FINE
*** Create AdditionalContactInfo schema -- FINE
........
*** Creating Tables -- FINE
*** Loading Data -- FINE
*** Adding Primary Keys -- FINE
*** Adding Indexes -- FINE
*** Creating XML index for each XML column -- FINE
*** Creating Foreign Key Constraints -- TROUBLE

Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Address_StateProvince_StateProvinceID". The conflict occurred in database "AdventureWorks", table "StateProvince", column 'StateProvinceID'.

Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_BillOfMaterials_Product_ComponentID". The conflict occurred in database "AdventureWorks", table "Product", column 'ProductID'.

ETC... <about 50 error messages follow>

*** Creating Table Triggers -- FINE
*** Creating Table Views - FINE
*** Creating Database Functions -- FINE
*** Creating Stored Procedures -- FINE
*** Creating Extended Properties

Database
Files and Filegroups
Schemas
Tables and Columns
Triggers
Views
Indexes
Constraints - PK, FK, DF, CK

Msg 15135, Level 16, State 19, Procedure sp_addextendedproperty, Line 42
Object is invalid. Extended properties are not permitted on 'Person.Address.FK_Address_StateProvince_StateProvinceID', or the object does not exist.

Msg 15135, Level 16, State 19, Procedure sp_addextendedproperty, Line 42
Object is invalid. Extended properties are not permitted on 'Production.BillOfMaterials.FK_BillOfMaterials_Product_ComponentID', or the object does not exist.

Msg 15135, Level 16, State 19, Procedure sp_addextendedproperty, Line 42
Object is invalid. Extended properties are not permitted on 'Production.BillOfMaterials.FK_BillOfMaterials_Product_ProductAssemblyID', or the object does not exist.

<about a hundred more such error messages>

Functions
Stored Procedures
XML Schemas
*** Disabling DDL Trigger for Database
*** Changing File Growth Values for Database
*** Shrinking Database
DBCC SHRINKDATABASE: File ID 1 of database ID 8 was skipped because the file does not have enough free space to reclaim.

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

Finished - 2005-10-20 09:20:32.123


How can I work through this set of errors

Thanks in advance.




Answer this question

instawdb.sql runtime errors

  • jus

    This is the directory I found it in. It came with the installation package, I guess. I think I installed the AdventureWorks at a later date.

    My SQL Server is on G:

    G:\program files\microsoft sql server\90\tools\samples\adventureworks oltp\instawdb.sql

    Thanks.

  • MSANCHEZS

    After reading this thread, I finally solved my Sample Databases(SD) problem. I previosly installed the SDs from trhe web. I was not able to attche it. After reading Greg's response, I uninstalled all the SDs previosly installed and went back to the CTP I downloaded, I re-ran it and it asked me if I wanted to install additional components, I then navigated to the SDs tree and selected to download all features. I think the next screen asked me if I would like to install and attach the SDs. I clicked the option. Before I knew it, U started querying the SDs.

    You might want to try that.

    Theo Medeiros.

  • mrpatel

    Can you tell me exactly where you downloaded instawdb.sql from   With Sept CTP, you should use the instawdb.sql that comes with the setup.  In Books Online, please see topic:

    "Running Setup to Install AdventureWorks Sample Databases and Samples"
  • instawdb.sql runtime errors
Answer this question