Data source

I've a question about this database sample. Is it an auto-generated data or a real data?

Id #21726 | Release: None | Updated: Feb 19 at 10:11 AM by aNoOoSe | Created: Feb 19 at 10:10 AM by aNoOoSe 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, 2014 at 2:55 AM by danielvl | Created: Oct 28, 2014 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, 2014 at 5:52 PM by nielsvdc | Created: Sep 30, 2014 at 5:32 PM by nielsvdc

Adventure Works 2008 mdf

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

Id #21381 | Release: None | Updated: Sep 25, 2014 at 8:38 PM by Junz05 | Created: Sep 25, 2014 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, 2014 at 10:35 PM by ericv009 | Created: Sep 8, 2014 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, 2014 at 7:33 PM by MRWheat | Created: Aug 29, 2014 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, 2014 at 6:56 PM by thomaswolfram | Created: Aug 20, 2014 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, 2014 at 9:23 AM by Rivanni | Created: Jun 25, 2014 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, 2014 at 5:35 PM by vikash_nda | Created: Feb 8, 2014 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, 2014 at 8:20 AM by kvic | Created: Jan 24, 2014 at 8:20 AM by kvic