asp.net session state method CanRetry does not retry on snapshot conflicts

In the CanRetry method the following if block should not have a exclamation point. if (!IsFatalSqlException(ex)) { return false; } We think it should be the following if (IsFatalSqlException(...

Id #21505 | Release: None | Updated: Nov 21 at 2:55 AM by danielvl | Created: Oct 28 at 7:02 PM by P47_Phoenix

Missing contact and individual tables

On the page about the XML datatype the example code mentions a schema collection Sales.IndividualSurveySchemaCollection that does not exist in any of the AdventureWorks databases (2008,2012,2014). ...

Id #21404 | Release: None | Updated: Sep 30 at 5:52 PM by nielsvdc | Created: Sep 30 at 5:32 PM by nielsvdc

Adventure Works 2008 mdf

Hey Guys, I'm looking for the adventure works mdf which contains the table person.contact Would anyone be able to assist as to where I can obtain it.

Id #21381 | Release: None | Updated: Sep 25 at 8:38 PM by Junz05 | Created: Sep 25 at 8:38 PM by Junz05

Issues with AdventureWorks 2012

Hi, I am trying to the SSRS tutorial "Create a Basic Table Report" and I had to setup the AdventureWorks2012 database, I have SQL 2012 Enterprise Edition. I downloaded the full backup zip of Adven...

Id #21280 | Release: None | Updated: Sep 8 at 10:35 PM by ericv009 | Created: Sep 8 at 10:35 PM by ericv009

I am getting an error message installing AdventureWorks

Hello all, I am very new to SQL and in an attempt to learn it I am planning to use the tutorial on MS pages. They recommend I install Adventureworks. So how do I do this? Instrcutions are non-ex...

Id #21264 | Release: None | Updated: Dec 5 at 7:33 PM by MRWheat | Created: Aug 29 at 11:07 PM by deguza

Wrong StateProvinces

The following query against the adventure works 2014 database reveals, that the german city "München" seems to be located in 4 different states (Hessen, Nordrhein-Westfalen, Saarland and the city-s...

Id #21246 | Release: None | Updated: Aug 20 at 6:56 PM by thomaswolfram | Created: Aug 20 at 6:56 PM by thomaswolfram

smproj type AdventureWorks Tabular Model samle cannot not be opened neither VS 2010 nor 2012

Hi, I downloaded the zip file, AdventureWorks Tabular Model SQL Server 2012, unblocked it as indicated in the instructions, the project can not be opened in VS 2010 nor 2012, I get the an error ind...

Id #21103 | Release: None | Updated: Aug 10 at 9:23 AM by Rivanni | Created: Jun 25 at 6:22 PM by eliassal

SELECT Sales.Customer

Hi! I'm no expert in sql but can someone explain to me why do I get different CustomerID list with these two queries: 1 SELECT TOP 1000 [CustomerID] ,[PersonID] ,[StoreID] ,[Terr...

Id #20716 | Release: None | Updated: Jul 10 at 5:35 PM by vikash_nda | Created: Feb 8 at 11:37 AM by bbahes

Running Script at Azure Database

I have pasted the AdventureWorks2012ForSQLAzure_Schema into my AZURE database I selected the estimate plan and after it finished running I get hundreds messages. Could someone explain why I am ha...

Id #20665 | Release: None | Updated: Jan 24 at 8:20 AM by kvic | Created: Jan 24 at 8:20 AM by kvic

AdventureWorksLT2012 data file attachment issue

having issues attaching AdventureWorksLt2012 mdf file to SQl 2012 express mgmt studio. Generating an error log stating 'access denied' .

Id #20622 | Release: None | Updated: Apr 26 at 1:15 AM by Esther106 | Created: Jan 14 at 1:20 AM by joeman67

OData app issue with edmxmlns

I downloaded AdventureWorks OData Feed from https://msftdbprodsamples.codeplex.com/releases/view/94064 It contains a service project and a test project. The test project includes this line of code:...

Id #20524 | Release: None | Updated: Dec 16, 2013 at 2:21 AM by tvanstiphout | Created: Dec 14, 2013 at 11:01 PM by tvanstiphout

Unable to process the cube

Opened the solution, but I'm getting an error during build regarding the impersonation mode. I tried changing the data source setting to all of the other options, but this error persists. Error ...

Id #20422 | Release: None | Updated: Nov 14, 2013 at 10:47 PM by hfulks | Created: Nov 14, 2013 at 10:47 PM by hfulks

Bug in schema creation script for Adventure Works for Azure SQL Database Federations

I'm getting the following error message: Msg 1902, Level 16, State 3, Line 2159 Cannot create more than one clustered index on table 'Production.BillOfMaterials'. Drop the existing clustered index ...

Id #20401 | Release: None | Updated: Jan 23 at 10:19 PM by gsacavdm | Created: Nov 9, 2013 at 2:04 AM by cb55555

Cant find the [dbo].[DimTime] for SSIS Tutorial: Creating a Simple ETL Package: Lesson 1

Hi am following the SSIS Tutorial: Creating a Simple ETL Package: Lesson 1 (http://technet.microsoft.com/en-us/library/84d0b877-603f-4f8e-bb6b-671558ade5c2). i have got to Step 6 http://technet.m...

Id #20340 | Release: None | Updated: Apr 20 at 10:47 PM by TexasBadger | Created: Oct 22, 2013 at 12:45 PM by curt69

AdventureWorks2008R2 not getting installed

Dear All I am trying to attach AdventureWorks2008R2_Data on my MS SQL 2008R2 Server, but it gaves me an error : _____TITLE: Microsoft SQL Server Management Studio Attach database failed for Serve...

Id #20207 | Release: None | Updated: Apr 26 at 1:17 AM by Esther106 | Created: Sep 18, 2013 at 8:00 AM by razasyedcse

missing relationship in AdventureWorks2012

hello all i'm trying to generate my entity model from the database AdventureWorks2012 using the "ADO.NET Entity Data Model" Wizard I choose to create all the entities ... and at the end of the ex...

Id #20183 | Release: None | Updated: Sep 18, 2013 at 7:49 AM by razasyedcse | Created: Sep 9, 2013 at 2:35 PM by Omarios

search the person.contact Table

Hello, i search the widly used Person.Contact Table. Which Release has it ? grretings Henrik

Id #20142 | Release: None | Updated: Aug 27, 2013 at 2:52 PM by Frodoger | Created: Aug 27, 2013 at 2:52 PM by Frodoger

Adventure Works 2012

Hi Guys, Trying to install the adventure works DB on SQL server Express 2013. I'm being told An error occurred while trying to attach database. Any feedback would help!

Id #20011 | Release: None | Updated: Nov 12, 2013 at 9:02 PM by AndreasKlein | Created: Jul 28, 2013 at 9:00 AM by Beginner2013

Unable to install federated DB

Hi, I was able to install the standard AdventureWorks DB on Azure but the but the federated version crashes with the following error. Any suggestions would be appreciated Creating Database Process...

Id #19763 | Release: None | Updated: Jul 18, 2013 at 7:59 PM by aadams | Created: May 25, 2013 at 8:09 AM by mat_guthrie

vNext not invented here

in the "Other Downloads" tab there is a vNext "placeholder for after SQL2008R2", but doesn't point to SQL2012. [chocolate teapot!]

Id #19736 | Release: None | Updated: May 20, 2013 at 12:27 PM by DickWonga | Created: May 20, 2013 at 12:27 PM by DickWonga

Missing "After Delete" Triggers!!!

There are two triggers In all "Detail Tables". It seems that in these tables we have missing "After Delete Triggers". It's obvious that if we delete one row in Detail Table we need to trigger Heade...

Id #19710 | Release: None | Updated: Sep 3, 2013 at 9:19 AM by SaeidHasani | Created: May 14, 2013 at 10:41 PM by SaeidHasani

AdventureWorksDW2012 missing "DimTime" table

Hi i am trying to do the tutorial "SSIS Tutorial: Creating a Simple ETL Package". It mentions a table called "DimTime" several times but i am not able to find it in AdventureWorksDW2012. I used the...

Id #19572 | Release: None | Updated: Apr 9, 2013 at 6:16 AM by shre0007 | Created: Apr 9, 2013 at 6:16 AM by shre0007

From AdventureWorks To AdventureWorksDW

AdventureWorks and AdventureWorksDW are good samples for transaction and dw. Is there any sample of SSIS package to load data from AdventureWorks to AdventureWorksDW? For example, I'd like to upd...

Id #19519 | Release: None | Updated: Mar 25, 2013 at 2:24 PM by bsurendiran | Created: Mar 25, 2013 at 2:24 PM by bsurendiran

Is there any document for Converting Advetureworks to AdventureworksDW

Hi Is there any document or guidance how the Adventureworks OLTP system has been converted into AdvetureworksDW (Datawarehouse).. I am new to datawarehouse concept and want to pracitce SSIS ... So...

Id #19518 | Release: None | Updated: Mar 25, 2013 at 2:21 PM by bsurendiran | Created: Mar 25, 2013 at 2:21 PM by bsurendiran

What are the Passwords in Person.Password?

Is there a default password for all users? I want to do some load testing but I cannot find any documentation anywhere on the web what the passwords are.

Id #19444 | Release: None | Updated: Apr 24, 2013 at 7:50 AM by Piet | Created: Mar 7, 2013 at 8:20 PM by fletch407

Dabatase Restore

I have observed that while restoring a database from a backup, if a database is in use, it does not allow to restore the database. I think that there should be an option (a checkbox or something) ...

Id #19427 | Release: None | Updated: Mar 5, 2013 at 10:18 AM by aniruddhaghoshal | Created: Mar 5, 2013 at 10:18 AM by aniruddhaghoshal

Create EF Model .edmx in visual studio

Hi Unable to generate the model because of the following exception: 'The table 'AdventureWorks2012.Production.Document' is referenced by a relationship, but cannot be found. SystemInformationID D...

Id #19334 | Release: None | Updated: Apr 21, 2013 at 3:21 PM by chg1226 | Created: Feb 11, 2013 at 10:06 AM by PhoenixNet

Multiple download links

I came across at atleast 3 links to download AdventureWorks databases for SQL Server 2012. These are the following: http://msftdbprodsamples.codeplex.com/releases/view/55330 http://msftdbprodsampl...

Id #19203 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by CivilEngine | Created: Jan 18, 2013 at 12:04 AM by 1mysorian2

Adventure Works DW 2012 download file is corrupt

The file is corrupt. Please upload a new working file.

Id #19135 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by toper | Created: Jan 4, 2013 at 9:14 AM by Sweepmaster

AdventureWorksDW2012_Data File is corrupt

There seams to be an issue with the AdventureWorksDW2012 Data file download. When I try to run this SQL statement: CREATE DATABASE AdventureWorksDW2012 ON (FILENAME = 'E:\MSSQL11.SQL02\MSSQL\DATA\A...

Id #19062 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by toper | Created: Dec 14, 2012 at 4:54 PM by dscheierman

AdventureWorksDW2012 Data File not working

Hi guys. Its impossible to download AdventureWorksDW2012 Data File. Best Regards

Id #19051 | Release: None | Updated: May 14, 2013 at 8:11 PM by mvtaylor0487 | Created: Dec 13, 2012 at 6:14 PM by HelderB

SQL Azure example not compatibel with Azure (heap)

The DatabaseLog table in the SQL Azure OLTP exampel does not have a clustered index which is not compatible with SQL Azure. It throws up wanrings in SSDt and SQL Azure generates an error when attem...

Id #18970 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by boduff | Created: Nov 25, 2012 at 2:45 PM by boduff

Reference Issue with Production.Document

Entity Framework reports the following error when attempting to generate an entity data model: Unable to generate the model because of the following exception: 'The table 'AdventureWorks2008.Produ...

Id #18636 | Release: None | Updated: Nov 18 at 6:33 AM by BradyKelly | Created: Sep 14, 2012 at 2:50 PM by prescottadam

AdventureWorks Databases – 2012, 2008R2 and 2008

Hello,   I uploaded AdventureWorks databases for 2012, 2008R2 and 2008 to http://msftdbprodsamples.codeplex.com/releases/view/93587. This release consolidates AdventureWorks databases for SQL Serve...

Id #18559 | Release: None | Updated: Apr 26 at 9:15 PM by eugeneandres | Created: Aug 30, 2012 at 12:31 AM by DerrickVMSFT

AdventureWorks2008

I need the MDF of this Project and I can't find it. The only available download is AdventureWorks2008R2 and this is not compatible with my machine. Can you help me? Thank you.

Id #18544 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by SpaceInvaders81 | Created: Aug 27, 2012 at 12:32 AM by SpaceInvaders81

SQL Server OLTP Scrip zip not working

When I click to download I am redirected with a message that says the down load will begin in 3 secounds and then nothing happens the download never begins - never happens.

Id #18514 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by codestr | Created: Aug 21, 2012 at 12:51 PM by codestr

This page should be updated to clearly state it will NOT work with VS2010.

to save the world man-years

Id #18220 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by arunsun | Created: Jun 11, 2012 at 11:47 PM by Eric6eyser

AdventureWorks 2008R2 Analysis Services Project

Anyone know when this will be available again? The download was taken down several days ago, and has not yet returned.

Id #18158 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by DerrickVMSFT | Created: May 30, 2012 at 7:17 PM by TomT1949

AdventureWorks 2008R2 Analysis Services Project Download

What has happened to the AdventureWorks 2008R2 Analysis Services Project download? It used to be part of the AdventureWorks2008R2_SR1.exe installer which is no longer available.

Id #18110 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by whartonj | Created: May 23, 2012 at 1:34 AM by whartonj

Sample Scripts for SQL Server 2008 (non-R2) SR4 Not to be found

The only scripts I have found in the folder location I used for installation were for the creation of the databases.   I searched for SR4 scripts and I only see SR3 out there, but there is no refe...

Id #17973 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by BlackBeard | Created: May 2, 2012 at 5:54 PM by EddyW

Production.Product not populated correctly

There is a mismatch between the RowIds for the records inserted in the SQL Azure database (federations) and the regular sql 2012 OLTP database. For e.g. in the SQL 2012 OLTP database the rowIds ar...

Id #17854 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by nlips | Created: Apr 16, 2012 at 3:09 AM by rbg8

AW2008FullTextCatalog in AW2012- Naming issue

Hi guys,   I think there's a small naming issue in the AdventureWorks2012 database. There's a FullText catalog named AW2008FullTextCatalog.   Regards, Daniel Altamirano

Id #17814 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by danielaltamirano | Created: Apr 11, 2012 at 10:04 PM by danielaltamirano

Incompatibilites with SQL Azure on Export/Import

I have downloaded the AdventureWorks Azure database to test the DAC Export/Import with it.   The followings are NOT Azure compliant and fail on export or import: The table DatabaseLog does not hav...

Id #17565 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by gabnaim | Created: Mar 9, 2012 at 3:09 PM by gabnaim

AdventureWorks2008R2_SR1 does not install

The samples does not install on Windows 7 machine with SQL Server R2 Developer edition (Default instance) and SQL Server Denali CTP3 (Names instance ), does not install successfully. The error that...

Id #16906 | Release: None | Updated: Sep 1 at 3:26 AM by richardfen | Created: Nov 15, 2011 at 9:40 AM by sudeept

SQL Server AdventureWorks 2008R2 SR1 download issue

tried many times but it just downloads 2 bytes of exe which gives error when I execute. Stuck with it and also is there any alternate sites to download?

Id #16840 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by ajjeys | Created: Nov 2, 2011 at 11:54 AM by sjegadison

Brunswick should be New Brunswick

The Canadian province of "New Brunswick" appears as "Brunswick" in the geography dimension.

Id #16724 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by dcorytableau | Created: Oct 11, 2011 at 11:57 PM by dcorytableau

AdventureWorks2008R2_SR1.exe will NOT install the OLTP DB correctly under Windows XP Pro

IMPORTANT: I have Windows XP Pro SP3. I installed the OLTB DB fine at home under Vista Ultimate and the same SQL config (2008 R2), with FILESTREAM enabled and FULL TEXT installed etc....   BEFO...

Id #16247 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by truste2007 | Created: Jul 12, 2011 at 11:12 PM by rothvin

Where can I get this installer adventureworks2008*.msi

I'm studying to get a certification 70-432 and after I install SQL SERVER 2008 I need to install two databases, Adventureworks and AdventureworksDW and the book says that I've to downloaded from th...

Id #16226 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by BlackBeard | Created: Jul 8, 2011 at 4:44 AM by juanfra

gyjujyg

jhvvjvhk

Id #16118 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by zkgbz | Created: Jun 16, 2011 at 9:14 PM by zkgbz

Unable to attach Adventureworks2008 DB to instances other than the default instance

I'm only able to install the Adventureworks2008 DB on one instance of SQL Server 2008. Any attempt to install the DB, using the installer (when using the installer after the first install, only th...

Id #15760 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by kiloez | Created: Apr 26, 2011 at 9:12 AM by kiloez

AdventureWorks2008 - Does not install

Howdy, I'm running into all kinds of issues regarding the SIMPLE install of AdventureWorks2008 database. It becomes one issue after another. I just want to demonstrate SSRS to my lead and others....

Id #15720 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by stanshapiro | Created: Apr 19, 2011 at 10:53 PM by CoviCo

Need AdventureWorks Sample DB 64-bit

I am getting the error message "This setup may only be run on an x86 platform". Can anybody provide the link to the 64-bit version of the AdventureWorks Sample Database msi.   Thanks!

Id #15631 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by saninnovator | Created: Apr 2, 2011 at 4:48 AM by bobbiej

vDateFeed

The SQL Server 2008 R2 developers kit contains HOL for Analysis Services. It references a view vDateFeed which is missing in the Sample Database AdventureWorksDW2008R2

Id #15629 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by noel_walsh | Created: Apr 1, 2011 at 12:19 PM by sippyhemant

AdventureWorks 2008R2 Reporting Services Samples

I have been trying to work through the sample reports for the AdventureWorks 2008R2 Reporting Service. All of the examples require the AdventureWorks2008R2 database. The download for AdventureWorks...

Id #15437 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by RickAtKnowWare | Created: Mar 1, 2011 at 6:31 PM by synres1

Nuget Packages

It would be awesome if the sample databases could be available in Nuget for SQL Express or SQLCompact. They could be added to the App_Data directory and add a connection string to the web.config.

Id #15403 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by Terrance | Created: Feb 23, 2011 at 3:22 AM by DarthObiwan

Foreign Key Error in AdventureWorksLT for SQL Azure

Telerik published a sample for reporting against Azure databases using ADO.net Entity Data Model. I loaded the AdventureWorksLT database to SQLAzure using the provided script (buildawltaz.cmd) but ...

Id #15088 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by EricFlamm | Created: Jan 12, 2011 at 3:19 PM by EricFlamm

AdventureWorks in french??

is there a french version for adventureWorks, if yes where can i found it??? thanks a lot

Id #15066 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by bzeggar | Created: Jan 9, 2011 at 2:03 PM by bzeggar

AdventureWorksDW missing SampleCurrencyData.txt

I installed the AdventureWorks 2008 sample database and it's missing the Integration Services tutorials. This is preventing me from moving through the "Creating a Simple ETL Package" tutorial. D...

Id #14852 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by jlbcloud | Created: Dec 10, 2010 at 1:24 AM by jlbcloud

AdventureWorks2008DW views for Data Mining are Empty

Using Adventure Works DW besides Training kit 70-448 (Business intelligence Development and maintenance by Erik Veeman) all seems to work fine 'till Chapter 9. (page 384 item number 4)   when try...

Id #14535 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by fvdgeer | Created: Oct 25, 2010 at 1:00 PM by jomaweb

Errors in the Text, SQL Azure (December CTP)

I found some errors in the text after installing AdventureWorks2008R2AZ.zip source code, 10811K, uploaded Dec 15 2009 in SQLAzure. Below are some examples.   Table: SalesLT.Address - Column: Addres...

Id #14170 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by hunterpaw | Created: Sep 2, 2010 at 5:41 PM by hunterpaw

AdventureWorks2008R2_RTM

This following file for sample database for sql 2008 is not working properly AdventureWorks2008R2_RTM.exe   so could i know alternate way to install sample db for sql server 2008 standard editio...

Id #14038 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by MrIanYates | Created: Aug 18, 2010 at 11:36 AM by teena

AdventureWorksDW not found

I can´t find AdventureWorksDW. SSIS 2008 Tutorials need AdventureWorksDW to run; I tried with AdventureWorksDW2008 but [DimTime] table doesn´t exists.   Where can I find it? thx.

Id #13773 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by DarrenBailey2008 | Created: Jul 22, 2010 at 11:48 AM by ZZircon

Deployment Adventure Works DW 2008 Errors

When you get an error deployment Adventure Works DW 2008 like this "Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure...

Id #13614 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by MinorMata | Created: Jun 28, 2010 at 4:45 AM by MinorMata

Adventure Works.partitions' is not valid and cannot be opened

On the build, show this error: Adventure Works.partitions' is not valid and cannot be opened. Check the 'C:\Program Files (x86)\Microsoft Learning\6234\MOD04\Labfiles\Adventure Works.partitions' fi...

Id #13540 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by SamirMMBr | Created: Jun 15, 2010 at 2:26 AM by SamirMMBr

Error: Object reference not set to an instance of an object

Hi, I'm trying to install the AdventureWorks 2008R2 database and I keep on receiving following error message: 'A fatal error occured during installation. Details: Object reference not set to an ins...

Id #13521 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by MrIanYates | Created: Jun 11, 2010 at 3:55 PM by VeeLdn

Can't Download

I can't download any files from any computer, when I click de .exe file the page reloads and that's all it does.

Id #13475 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by ccalvo | Created: Jun 7, 2010 at 6:11 PM by ccalvo

Installer crashes when SQL Server service is not started

If the SQL Server service is not started, an exception is thrown during the installation and it terminates. (NullReferenceException)   If the service is started and the installer is run again, it w...

Id #13392 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by MrIanYates | Created: May 31, 2010 at 6:36 AM by iravanchi

SQL Server 2008 R2 Samples

Has anyone tried the CTP samples following the Tutorials with the final release. Analysis Services examples don't work for me. Is this a localization problem the same as installing 2008R2. I have c...

Id #13244 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by robbieaus | Created: May 21, 2010 at 11:53 PM by robbieaus

AdventureWorks2008_SR4.exe will not download

After the Microsoft Public License window pops up I click "I Agree" but from there it just waits forever for a response from the codeplex site and eventually just times out. I can download other f...

Id #13131 | Release: None | Updated: Mar 27, 2013 at 7:51 PM by stevekirchner | Created: May 18, 2010 at 3:56 PM by jaimebarraza

problem downloading AdventureWorks2008R2_NovemberCTP.exe

I have been trying to download the sample AdventureWorks2008 databases, specifically AdventureWorks2008R2_NovemberCTP.exe, but when I get to the screen where you Select which databases to download,...

Id #12746 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by jvtcodeplex | Created: Apr 16, 2010 at 3:03 PM by jvtcodeplex

problem downloading AdventureWorks2008R2_NovemberCTP.exe

I have been trying to download the sample AdventureWorks2008 databases, specifically AdventureWorks2008R2_NovemberCTP.exe, but when I get to the screen where you Select which databases to download,...

Id #12737 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by jvtcodeplex | Created: Apr 16, 2010 at 2:24 AM by jvtcodeplex

problem downloading AdventureWorks2008R2_NovemberCTP.exe

I have been trying to download the sample AdventureWorks2008 databases, specifically AdventureWorks2008R2_NovemberCTP.exe, but when I get to the screen where you Select which databases to download,...

Id #12736 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by jvtcodeplex | Created: Apr 16, 2010 at 2:24 AM by jvtcodeplex

problem downloading AdventureWorks2008R2_NovemberCTP.exe

I have been trying to download the sample AdventureWorks2008 databases, specifically AdventureWorks2008R2_NovemberCTP.exe, but when I get to the screen where you Select which databases to download,...

Id #12735 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by jvtcodeplex | Created: Apr 16, 2010 at 2:20 AM by jvtcodeplex

Operating system error -2147024891: "0x80070005(Access is denied.)".

Windows XP with SP3 updates. This error keep coming up and stop the AdvertureWorks2008 db from installing. Why?   Error: Unable to open the physical file "C:\Program Files\ Microsoft SQL Server\MS...

Id #12732 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by mperillo | Created: Apr 15, 2010 at 5:56 PM by ctatum

Cannot install the 'AdventureWorks 2008 OLTP' database.

I have downloaded and executed "AdventureWorks2008_SR4.exe" and I am unable to install the 'AdventureWorks 2008 OLTP' database.   During the installation, I have confirmed that the option 'Adventur...

Id #12501 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by mperillo | Created: Apr 5, 2010 at 9:23 AM by jack123

Adventureworks 2005 Will Not Install

After click I Agree and Next, Adventureworks 2005 displays error 1327 for invalid drive and terminates installation.

Id #12397 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by lsvmary4 | Created: Mar 31, 2010 at 9:29 PM by lsvmary4

Modify SQL Azure samples to run in a single database

The SQL Azure samples are great!   Because the pricing model for SQL Azure is per database it would be very helpful if the sample allowed a user to specify the database name. It would also be coo...

Id #12115 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by ZachSkylesOwens | Created: Mar 18, 2010 at 5:32 PM by ZachSkylesOwens

AdventureWorks2008R2_NovemberCTP.exe does not work

When running this setup, after I check the "I Accept the licence terms" check box, and click the "Next" button, the next screen pops up with "A fatal error occurred during installation. Details: Ob...

Id #12042 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by KevinBurton | Created: Mar 9, 2010 at 6:54 AM by mmojsovski

Adventure Work 2008 Entity Model

I still don't understand the 'BusinessContact' entity. It has a 'many' to 'one' association with 'Person' and a 'many' to 'many' association with 'BusinessEntity' entity. How can that work? Anyone ...

Id #11266 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by CMella68 | Created: Dec 20, 2009 at 2:09 AM by kevinxu

FILESTREAM feature is disabled

When trying to install the AdventureWorks sample database on a SQL Server 2008 instance via the sample scripts, I get the "FILESTREAM feature is disabled." error message.

Id #11074 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by SimonaP | Created: Dec 7, 2009 at 4:52 PM by bobtesch

Adventureworks SR3 fails to install

I have tried to instal Adventureworks on a new installation of SQL SERVER EXPRESS SP1. I have ensured that both FILESTREAM and Full-Text are enabled. After the installer asks for the instance to be...

Id #11013 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by MacNala | Created: Nov 27, 2009 at 10:51 PM by MacNala

File System Error Deploying AdventureWorks

I installed AdventureWorksDW2008 on a drive different than default C: and opened the solution file to deploy the cubes to the SSAS 2008 server and got this error message:   Error 1 File system erro...

Id #11008 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by dslaby | Created: Nov 26, 2009 at 9:47 PM by dslaby

AdventureWorks2008R2_NovemberCTP.exe fails on second page

Windows Server 2008 R2 x64 MOSS 2010 Nov Beta installed SQL Gemini (Nov CTP) installed to configure MOSS SQL Server 2008 R2 (Nov CTP) installed as default instance SSAS (2008 R2 Nov CTP) installed ...

Id #10986 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by mausch | Created: Nov 23, 2009 at 6:55 AM by philoj

AdventureWorks2008R2_NovemberCTP.exe works only on default instance

Sql 20008 R2 november ctp installed as named instace , On teh same server a default Sql 2005 is present   THe following errors happen while executing AdventureWorks2008R2_NovemberCTP.exe If the ...

Id #10952 | Release: None | Updated: Jun 14, 2013 at 8:36 AM by gbologna | Created: Nov 17, 2009 at 3:59 PM by rafcnbms

Issues with Configuration Wizard - SSRS Demo (Microsoft SQL Server 2008 for Developers Training Kit

The Configuration Wizard keeps coming up with "missing dependencies" on the steps of the SQL Server AdventureWorks 2008 Sample Database and Microsoft SQL Server 2008 Reporting Services Samples. Cli...

Id #10933 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by billmarmc | Created: Nov 13, 2009 at 11:59 AM by billmarmc

KJDatabaseInstaller: There are two orphaned folder "..svnbridge" after installing.

Environment: Windows 2008 R2 ENU KJ 10.50.1352.12 Sample 91106   Repro Steps: Run *.exe by default steps. Take a view the files under folder "...Samples\AdventureWorks 2008R2 Analysis Services P...

Id #10902 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by libinzhao | Created: Nov 9, 2009 at 8:38 AM by libinzhao

KJDatabaseInstaller: RUS: There is a error dialog after extracting files.

Environment: Windows 2008 R2 RUS KJ 10.50.1352.12 Sample 91106   Repro Steps: Double click the installer *.exe file. Wait for extractiong files.   Expectations: There is setup window after ext...

Id #10891 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by libinzhao | Created: Nov 6, 2009 at 9:41 AM by libinzhao

AdventureWorks 2008 SR3 installer ends prematurely - found a fix

Installing AW2008 SR3 on SQL Server 2008 (SP1) - 10.0.2531.0 Enterprise Evaluation, running on Windows Server 2003 (SP2) Standard Edition, using the .msi.   When I run the installer, it gets to the...

Id #10879 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by rkl3011 | Created: Nov 4, 2009 at 11:42 AM by simonliddle

Suggestion: Add more data

Consider adding more data to OLTP and datawarehouse, or providing a tool which could scale the databases to a much larger size.

Id #10805 | Release: SQL vNext | Updated: Feb 22, 2013 at 3:06 AM by philoj | Created: Oct 20, 2009 at 6:55 PM by bonniefe

Suggestion: AS database is easily configured to contain realistic "current date" data

In certain types of demos or tests it's helpful if the AS database 1) has a member that really aligns to current server day/time and 2) only includes data processed through that day, no data beyond...

Id #10759 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by philoj | Created: Oct 14, 2009 at 12:48 AM by wadedor

CreateAdventureWorksOLAP.cmd: Failed to Deploy and process the enterprise version of “AdventureWorks Analysis Services Project” by CreateAdventureWorksOLAP.cmd.

Environment: Windows 2003 ENU AMD64 KJ 10.50.1093.00 Sample 90820   Repro Steps: Open the cmd console, locate to “…\ Microsoft SQL Server\100\Tools\Samples”. Type the following command  to Deplo...

Id #10519 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by edlehman | Created: Aug 25, 2009 at 9:39 AM by libinzhao

Adventureworks databases will not install

When I download and run the all adventure works msi file for x86 the Ms sql server 2008 AdventureWorks Database Refresh1 Samples Dialog Appears With Change, Repair or Remove Options only Remove is...

Id #10442 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by mperillo | Created: Aug 12, 2009 at 7:00 AM by follini

Add city/state/province/country outlines as geospatial data

Add city/state/province/country outlines as geospatial data in the AW2008 sample database.

Id #10203 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by bobb | Created: Jun 27, 2009 at 12:46 AM by bonniefe

Visual Studio 2008: Unable to use Browse feature in Analysis Service Project

I am using AdventureWorks, the downloadable sample database application that I can open directly using Visual Studio (Adventure Works.sln). My question applies to both the standard and enterprise ...

Id #10175 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by peterfrb2 | Created: Jun 23, 2009 at 2:10 AM by peterfrb2

Broken 2005 download link

http://codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004 - gets page error.

Id #9870 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by harleydk | Created: Apr 27, 2009 at 3:05 PM by harleydk

Error code 2738 encountered when executing SQL2008.AdventureWorks_All_Databases.x86.msi

Received error message: "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2738"

Id #9868 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by DogPound48 | Created: Apr 27, 2009 at 1:17 PM by DogPound48

Version bump issue in Production. Document table

In AdventureWorks2008, the Filename column in Production. Document table contains Yukon pathnames, …\Microsoft SQL Server\MSSQL.1\… .   Given that the document files are not actually in the file s...

Id #9637 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by marshow | Created: Mar 31, 2009 at 2:35 AM by marshow

AW-for-SQL11: convert documents in Production.Document table to Word 2007

For the SQL11 version of AdventureWorks, the documents in the Document column of the Production.Document table will need to be converted to Word 2007 documents, and the values in the FileExtension ...

Id #9636 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by marshow | Created: Mar 31, 2009 at 2:33 AM by marshow

EmailPromotion may be misplaced in the data model.

Taken from discussion @ the MVP Global Summit 2009.   What is emailPromotion (in the Person table)? Maybe should move to customer information, not person information. Denote that this is more about...

Id #9546 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by ReedMe | Created: Mar 17, 2009 at 5:54 PM by ReedMe

Pricing model in AW is too simplistic and not reflective of the real world scenarios. Minimum, must show original price and new price. Calculations based on events is a common thing outside of pricing scenarios, as well.

Taken from discussion @ the MVP Global Summit 2009.

Id #9545 | Release: None | Updated: Feb 22, 2013 at 3:06 AM by ReedMe | Created: Mar 17, 2009 at 5:53 PM by ReedMe