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: May 25 at 7:09 AM by mat_guthrie | Created: May 25 at 7:09 AM by mat_guthrie
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 at 11:27 AM by DickWonga | Created: May 20 at 11:27 AM by DickWonga
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: May 14 at 9:41 PM by SaeidHasani | Created: May 14 at 9:41 PM by SaeidHasani
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 at 5:16 AM by shre0007 | Created: Apr 9 at 5:16 AM by shre0007
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 at 1:24 PM by bsurendiran | Created: Mar 25 at 1:24 PM by bsurendiran
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 at 1:21 PM by bsurendiran | Created: Mar 25 at 1:21 PM by bsurendiran
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 at 6:50 AM by Piet | Created: Mar 7 at 7:20 PM by fletch407
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 at 9:18 AM by aniruddhaghoshal | Created: Mar 5 at 9:18 AM by aniruddhaghoshal
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 at 2:21 PM by chg1226 | Created: Feb 11 at 9:06 AM by PhoenixNet
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 at 2:06 AM by CivilEngine | Created: Jan 17 at 11:04 PM by 1mysorian2
The file is corrupt. Please upload a new working file.
Id #19135 | Release:
None
| Updated: Feb 22 at 2:06 AM by toper | Created: Jan 4 at 8:14 AM by Sweepmaster
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 at 2:06 AM by toper | Created: Dec 14, 2012 at 3:54 PM by dscheierman
Hi guys.
Its impossible to download AdventureWorksDW2012 Data File.
Best Regards
Id #19051 | Release:
None
| Updated: May 14 at 7:11 PM by mvtaylor0487 | Created: Dec 13, 2012 at 5:14 PM by HelderB
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 at 2:06 AM by boduff | Created: Nov 25, 2012 at 1:45 PM by boduff
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: Apr 25 at 4:00 AM by Wattana | Created: Sep 14, 2012 at 1:50 PM by prescottadam
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: May 14 at 8:11 PM by spelluru | Created: Aug 29, 2012 at 11:31 PM by DerrickVMSFT
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 at 2:06 AM by SpaceInvaders81 | Created: Aug 26, 2012 at 11:32 PM by SpaceInvaders81
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 at 2:06 AM by codestr | Created: Aug 21, 2012 at 11:51 AM by codestr
to save the world man-years
Id #18220 | Release:
None
| Updated: Feb 22 at 2:06 AM by arunsun | Created: Jun 11, 2012 at 10:47 PM by Eric6eyser
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 at 2:06 AM by DerrickVMSFT | Created: May 30, 2012 at 6:17 PM by TomT1949
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 at 2:06 AM by whartonj | Created: May 23, 2012 at 12:34 AM by whartonj
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 at 2:06 AM by BlackBeard | Created: May 2, 2012 at 4:54 PM by EddyW
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 at 2:06 AM by nlips | Created: Apr 16, 2012 at 2:09 AM by rbg8
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 at 2:06 AM by danielaltamirano | Created: Apr 11, 2012 at 9:04 PM by danielaltamirano
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 at 2:06 AM by gabnaim | Created: Mar 9, 2012 at 2:09 PM by gabnaim
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: Feb 22 at 2:06 AM by steenp | Created: Nov 15, 2011 at 8:40 AM by sudeept
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 at 2:06 AM by ajjeys | Created: Nov 2, 2011 at 10:54 AM by sjegadison
The Canadian province of "New Brunswick" appears as "Brunswick" in the geography dimension.
Id #16724 | Release:
None
| Updated: Feb 22 at 2:06 AM by dcorytableau | Created: Oct 11, 2011 at 10:57 PM by dcorytableau
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 at 2:06 AM by truste2007 | Created: Jul 12, 2011 at 10:12 PM by rothvin
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 at 2:06 AM by BlackBeard | Created: Jul 8, 2011 at 3:44 AM by juanfra
jhvvjvhk
Id #16118 | Release:
None
| Updated: Feb 22 at 2:06 AM by zkgbz | Created: Jun 16, 2011 at 8:14 PM by zkgbz
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 at 2:06 AM by kiloez | Created: Apr 26, 2011 at 8:12 AM by kiloez
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 at 2:06 AM by stanshapiro | Created: Apr 19, 2011 at 9:53 PM by CoviCo
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 at 2:06 AM by saninnovator | Created: Apr 2, 2011 at 3:48 AM by bobbiej
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 at 2:06 AM by noel_walsh | Created: Apr 1, 2011 at 11:19 AM by sippyhemant
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 at 2:06 AM by RickAtKnowWare | Created: Mar 1, 2011 at 5:31 PM by synres1
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 at 2:06 AM by Terrance | Created: Feb 23, 2011 at 2:22 AM by DarthObiwan
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 at 2:06 AM by EricFlamm | Created: Jan 12, 2011 at 2:19 PM by EricFlamm
is there a french version for adventureWorks, if yes where can i found it??? thanks a lot
Id #15066 | Release:
None
| Updated: Feb 22 at 2:06 AM by bzeggar | Created: Jan 9, 2011 at 1:03 PM by bzeggar
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 at 2:06 AM by jlbcloud | Created: Dec 10, 2010 at 12:24 AM by jlbcloud
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 at 2:06 AM by fvdgeer | Created: Oct 25, 2010 at 12:00 PM by jomaweb
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 at 2:06 AM by hunterpaw | Created: Sep 2, 2010 at 4:41 PM by hunterpaw
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 at 2:06 AM by MrIanYates | Created: Aug 18, 2010 at 10:36 AM by teena
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 at 2:06 AM by DarrenBailey2008 | Created: Jul 22, 2010 at 10:48 AM by ZZircon
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 at 2:06 AM by MinorMata | Created: Jun 28, 2010 at 3:45 AM by MinorMata
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 at 2:06 AM by SamirMMBr | Created: Jun 15, 2010 at 1:26 AM by SamirMMBr
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 at 2:06 AM by MrIanYates | Created: Jun 11, 2010 at 2:55 PM by VeeLdn
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 at 2:06 AM by ccalvo | Created: Jun 7, 2010 at 5:11 PM by ccalvo
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 at 2:06 AM by MrIanYates | Created: May 31, 2010 at 5:36 AM by iravanchi
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 at 2:06 AM by robbieaus | Created: May 21, 2010 at 10:53 PM by robbieaus
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 at 6:51 PM by stevekirchner | Created: May 18, 2010 at 2:56 PM by jaimebarraza
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 at 2:06 AM by jvtcodeplex | Created: Apr 16, 2010 at 2:03 PM by jvtcodeplex
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 at 2:06 AM by jvtcodeplex | Created: Apr 16, 2010 at 1:24 AM by jvtcodeplex
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 at 2:06 AM by jvtcodeplex | Created: Apr 16, 2010 at 1:24 AM by jvtcodeplex
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 at 2:06 AM by jvtcodeplex | Created: Apr 16, 2010 at 1:20 AM by jvtcodeplex
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 at 2:06 AM by mperillo | Created: Apr 15, 2010 at 4:56 PM by ctatum
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 at 2:06 AM by mperillo | Created: Apr 5, 2010 at 8:23 AM by jack123
After click I Agree and Next, Adventureworks 2005 displays error 1327 for invalid drive and terminates installation.
Id #12397 | Release:
None
| Updated: Feb 22 at 2:06 AM by lsvmary4 | Created: Mar 31, 2010 at 8:29 PM by lsvmary4
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 at 2:06 AM by ZachSkylesOwens | Created: Mar 18, 2010 at 4:32 PM by ZachSkylesOwens
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 at 2:06 AM by KevinBurton | Created: Mar 9, 2010 at 5:54 AM by mmojsovski
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 at 2:06 AM by CMella68 | Created: Dec 20, 2009 at 1:09 AM by kevinxu
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 at 2:06 AM by SimonaP | Created: Dec 7, 2009 at 3:52 PM by bobtesch
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 at 2:06 AM by MacNala | Created: Nov 27, 2009 at 9:51 PM by MacNala
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 at 2:06 AM by dslaby | Created: Nov 26, 2009 at 8:47 PM by dslaby
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 at 2:06 AM by mausch | Created: Nov 23, 2009 at 5:55 AM by philoj
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: Fri at 7:36 AM by gbologna | Created: Nov 17, 2009 at 2:59 PM by rafcnbms
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 at 2:06 AM by billmarmc | Created: Nov 13, 2009 at 10:59 AM by billmarmc
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 at 2:06 AM by libinzhao | Created: Nov 9, 2009 at 7:38 AM by libinzhao
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 at 2:06 AM by libinzhao | Created: Nov 6, 2009 at 8:41 AM by libinzhao
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 at 2:06 AM by rkl3011 | Created: Nov 4, 2009 at 10:42 AM by simonliddle
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 at 2:06 AM by philoj | Created: Oct 20, 2009 at 5:55 PM by bonniefe
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 at 2:06 AM by philoj | Created: Oct 13, 2009 at 11:48 PM by wadedor
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 at 2:06 AM by edlehman | Created: Aug 25, 2009 at 8:39 AM by libinzhao
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 at 2:06 AM by mperillo | Created: Aug 12, 2009 at 6:00 AM by follini
Add city/state/province/country outlines as geospatial data in the AW2008 sample database.
Id #10203 | Release:
None
| Updated: Feb 22 at 2:06 AM by bobb | Created: Jun 26, 2009 at 11:46 PM by bonniefe
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 at 2:06 AM by peterfrb2 | Created: Jun 23, 2009 at 1:10 AM by peterfrb2
http://codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004 - gets page error.
Id #9870 | Release:
None
| Updated: Feb 22 at 2:06 AM by harleydk | Created: Apr 27, 2009 at 2:05 PM by harleydk
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 at 2:06 AM by DogPound48 | Created: Apr 27, 2009 at 12:17 PM by DogPound48
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 at 2:06 AM by marshow | Created: Mar 31, 2009 at 1:35 AM by marshow
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 at 2:06 AM by marshow | Created: Mar 31, 2009 at 1:33 AM by marshow
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 at 2:06 AM by ReedMe | Created: Mar 17, 2009 at 4:54 PM by ReedMe
Taken from discussion @ the MVP Global Summit 2009.
Id #9545 | Release:
None
| Updated: Feb 22 at 2:06 AM by ReedMe | Created: Mar 17, 2009 at 4:53 PM by ReedMe
Taken from discussion @ the MVP Global Summit 2009.
Id #9543 | Release:
None
| Updated: Feb 22 at 2:06 AM by ReedMe | Created: Mar 17, 2009 at 4:50 PM by ReedMe
Taken from discussion @ the MVP Global Summit 2009.
Id #9542 | Release:
None
| Updated: Feb 22 at 2:06 AM by rfessler | Created: Mar 17, 2009 at 4:49 PM by ReedMe
Taken from discussion @ the MVP Global Summit 2009.
Id #9541 | Release:
None
| Updated: Feb 22 at 2:06 AM by CERobertson | Created: Mar 17, 2009 at 4:24 PM by ReedMe
Taken from discussion @ the MVP Global Summit 2009.
Id #9540 | Release:
None
| Updated: Feb 22 at 2:06 AM by ReedMe | Created: Mar 17, 2009 at 4:22 PM by ReedMe
Taken from discussion @ the MVP Global Summit 2009.
Id #9539 | Release:
None
| Updated: Feb 22 at 2:06 AM by PapyNormand | Created: Mar 17, 2009 at 4:16 PM by ReedMe
dbo.FactCallCenter is a table that was added to AdventureWorks to support neural network and logistic regression data mining models. The original data used for analysis included a column for day of...
Id #9342 | Release:
None
| Updated: Feb 22 at 2:06 AM by PatriceCalve | Created: Feb 24, 2009 at 5:12 PM by Jeannine
I am getting following error while attaching the database in management studio.
TITLE: Microsoft SQL Server Management Studio Express
Failed to retrieve data for this request. (Microsoft.SqlSe...
Id #9249 | Release:
None
| Updated: Feb 22 at 2:06 AM by antonsea | Created: Feb 13, 2009 at 11:06 AM by ajay75
I wanted to create a nice example of a master/details data selection. I wanted a dropdown list of customers; given the selected customer, I'd display the SalesOrderHeaders for the customer, etc.
...
Id #9159 | Release:
None
| Updated: Feb 22 at 2:06 AM by johnwsaundersiii | Created: Feb 4, 2009 at 12:16 PM by johnwsaundersiii
I believe there are too many steps involved if anyone wants to have Analysis Services sample database installed on their PC, and there are dependency on OLTP database as well. It would be very nice...
Id #9135 | Release:
None
| Updated: Feb 22 at 2:06 AM by vidas_m | Created: Feb 2, 2009 at 1:31 PM by vidas_m
Please include (is needed via a separate download) larger data sets. When doing demos on index tuning larger data sets make it much easier to get the point across, but to make the code available t...
Id #9126 | Release:
None
| Updated: Feb 22 at 2:06 AM by mrdenny | Created: Jan 31, 2009 at 10:02 PM by mrdenny
Request the addition of more full-text content, including additional documents, XML, and CLOB/NCLOB character data. There is currently very little data specifically to take advantage of the full-t...
Id #9059 | Release:
None
| Updated: Feb 22 at 2:06 AM by Tupacs01 | Created: Jan 28, 2009 at 1:02 AM by Tupacs01
The default example should be:
CreateAdventureWorks.cmd "." "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\" "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\"
Id #9010 | Release:
None
| Updated: Feb 22 at 2:06 AM by edlehman | Created: Jan 22, 2009 at 9:19 PM by ReedMe
as an author using AdventureWorks2008 as my sample database, I want my code to work on a case sensitive collation server. The previous AdventureWorks had a case sensitive version, 2008 needs it too.
Id #8953 | Release:
None
| Updated: Feb 22 at 2:06 AM by VIvanov | Created: Jan 18, 2009 at 2:18 AM by PaulNielsenSQL
Environment:
SQL Server Katmai
SQL Samples
Visio
Repro Steps:
Open ‘<SampleRoot>\ Tools\Samples\AdventureWorks LT\ AdventureWorksLT.vsd’ via Visio
Check the columns of table ‘Customer’
Select ...
Id #8939 | Release:
None
| Updated: Feb 22 at 2:06 AM by leilu | Created: Jan 16, 2009 at 5:11 AM by leilu
Environment:
SQL Server Katmai
SQL Samples
Repro Steps:
Open ‘<SampleRoot>\ Tools\Samples\AdventureWorks LT\ AdventureWorksLT.vsd’ via Visio
Check Name of Relation between Tables ‘Customer’ an...
Id #8938 | Release:
None
| Updated: Feb 22 at 2:06 AM by leilu | Created: Jan 16, 2009 at 5:11 AM by leilu
Environment:
SQL Server Katmai
SQL Samples
Visio
Repro Steps:
Open ‘<SampleRoot>\ Tools\Samples\AdventureWorks Data Warehouse\ AdventureWorksDW.vsd’ via Visio
Select Tables and Columns in DB ‘...
Id #8937 | Release:
None
| Updated: Feb 22 at 2:06 AM by leilu | Created: Jan 16, 2009 at 5:11 AM by leilu
Environment:
SQL Server Katmai
SQL Samples
Visio
Repro Steps:
Open ‘<SampleRoot>\ Tools\Samples\AdventureWorks 2008 Data Warehouse\ AdventureWorksDW.vsd’ via Visio
Select Tables and Columns in...
Id #8936 | Release:
None
| Updated: Feb 22 at 2:06 AM by leilu | Created: Jan 16, 2009 at 5:11 AM by leilu
Environment:
SQL Server Katmai
SQL Samples
Visio
Repro Steps:
Open ‘<SampleRoot>\ Tools\Samples\AdventureWorks 2008 LT\ AdventureWorksLT.vsd’ via Visio
Check the columns of table ‘Customer’
Se...
Id #8935 | Release:
None
| Updated: Feb 22 at 2:06 AM by leilu | Created: Jan 16, 2009 at 5:11 AM by leilu