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:
| Updated: Wed at 5:56 PM by thomaswolfram | Created: Wed at 5:56 PM by thomaswolfram
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:
| Updated: Aug 10 at 8:23 AM by Rivanni | Created: Jun 25 at 5:22 PM by eliassal
I'm no expert in sql but can someone explain to me why do I get different CustomerID list with these two queries:
SELECT TOP 1000 [CustomerID]
Id #20716 | Release:
| Updated: Jul 10 at 4:35 PM by vikash_nda | Created: Feb 8 at 10:37 AM by bbahes
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:
| Updated: Jan 24 at 7:20 AM by kvic | Created: Jan 24 at 7:20 AM by kvic
having issues attaching AdventureWorksLt2012 mdf file to SQl 2012 express mgmt studio. Generating an error log stating 'access denied' .
Id #20622 | Release:
| Updated: Apr 26 at 12:15 AM by Esther106 | Created: Jan 14 at 12:20 AM by joeman67
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:
| Updated: Dec 16, 2013 at 1:21 AM by tvanstiphout | Created: Dec 14, 2013 at 10:01 PM by tvanstiphout
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.
Id #20422 | Release:
| Updated: Nov 14, 2013 at 9:47 PM by hfulks | Created: Nov 14, 2013 at 9:47 PM by hfulks
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:
| Updated: Jan 23 at 9:19 PM by gsacavdm | Created: Nov 9, 2013 at 1:04 AM by cb55555
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:
| Updated: Apr 20 at 9:47 PM by TexasBadger | Created: Oct 22, 2013 at 11:45 AM by curt69
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:
| Updated: Apr 26 at 12:17 AM by Esther106 | Created: Sep 18, 2013 at 7:00 AM by razasyedcse