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 9:35 PM by ericv009 | Created: Sep 8 at 9: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: Aug 29 at 10:07 PM by deguza | Created: Aug 29 at 10: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 5:56 PM by thomaswolfram | Created: Aug 20 at 5: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 8:23 AM by Rivanni | Created: Jun 25 at 5: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 4:35 PM by vikash_nda | Created: Feb 8 at 10: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 7:20 AM by kvic | Created: Jan 24 at 7: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 12:15 AM by Esther106 | Created: Jan 14 at 12:20 AM by joeman67

OData app issue with edmxmlns

I downloaded AdventureWorks OData Feed from 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 1:21 AM by tvanstiphout | Created: Dec 14, 2013 at 10: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 9:47 PM by hfulks | Created: Nov 14, 2013 at 9: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 9:19 PM by gsacavdm | Created: Nov 9, 2013 at 1:04 AM by cb55555