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: Feb 8 at 11:23 AM by bbahes | 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 8 at 11:21 AM by shreyas14 | Created: Jan 14 at 12: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 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

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: Oct 22, 2013 at 1:13 PM by curt69 | Created: Oct 22, 2013 at 11:45 AM 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: Nov 3, 2013 at 8:27 AM by singhswat | Created: Sep 18, 2013 at 7: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 6:49 AM by razasyedcse | Created: Sep 9, 2013 at 1: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 1:52 PM by Frodoger | Created: Aug 27, 2013 at 1:52 PM by Frodoger