Trouble Opening the AdventureWorks2012_Data.mdf

After uploading the AdventureWorks 2012, and trying to attach it to SQL it gave me an error box it state This file does not have a program associated with it for performing this action. Please ins...

Id #21993 | Release: None | Updated: Wed at 5:24 AM by johnsolas81 | Created: Wed at 5:24 AM by johnsolas81

Adventure Works 2014 OLTP Script causes an error due to missing new line in PersonPhone.csv

Current behaviour: If you run Adventure Works 2014 OLTP Script straight from download the script doesn't complete successfully Reproduction steps: 10) Download the Adventure Works 2014 OLTP Script...

Id #21983 | Release: None | Updated: Aug 20 at 9:33 AM by jlwatts | Created: Aug 20 at 9:33 AM by jlwatts

DQS - Data Quality Project Matching Export Fails

I receive an unhandled exception error when I go to export the matching results of the data quality services project into a new table. The dqs_services service account has db_owner permissions to ...

Id #21843 | Release: None | Updated: May 7 at 5:13 PM by brianpowers27 | Created: May 7 at 5:13 PM by brianpowers27

Distinct SessionId across multiple virtual IIS apps

ASP.NET Session State Provider for SQL Server In-Memory OLTP if I have multiple apps under the same domain: www.somedomain.com/Admin www.somedomain.com/Statistics www.somedomain.com/Shop If I loa...

Id #21835 | Release: None | Updated: May 4 at 8:35 AM by Shalke | Created: May 4 at 8:33 AM by Shalke

Sample

Hi there, I'm using SQL Server 2014 Developer Edition and AW2014 I could not run this scripts on AW2014 I'm getting error Database and server triggers on DDL statements DROP and CREATE are not su...

Id #21773 | Release: None | Updated: Mar 14 at 4:22 PM by odeddror | Created: Mar 14 at 4:22 PM by odeddror

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 9:11 AM by aNoOoSe | Created: Feb 19 at 9:10 AM by aNoOoSe

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: Jul 2 at 11:06 PM by P47_Phoenix | Created: Oct 28, 2014 at 6: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 4:52 PM by nielsvdc | Created: Sep 30, 2014 at 4: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, 2014 at 7:38 PM by Junz05 | Created: Sep 25, 2014 at 7: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 9:35 PM by ericv009 | Created: Sep 8, 2014 at 9:35 PM by ericv009