.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Adventure Wprks

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

Hi Guys,

I have managed to attach the 2005 version of Adventure Works to my SQLExpress installation. In Visual Studio 2010 I have created a new windows project andtried to add a new data source. I have selected option 5 - MS SQLserver Database file, and browsed to the selected database. The Test Connection function succeeds, but when I press OK, I get the follwing error message:Unable to add  data connection. Could not find file or assembly "microsoft.sqlserver.management.sdk.sfc.version=10.0.0,culture=neutral, publickeytoken =89845dcd8080cc91".

I guess I am looking for a download here to fix the problem. Any Ideas?

View Complete Post

More Related Resource Links

Financial Reporting Measure Group question in Adventure Works 2008 R2


I need some help understanding the Financial Reporting measure group in Adventure Works 2008 R2. I get a value of $12,609.503 when I just drag amount into the query pane. Which accounts is this made up of, and how does it get to this result? Thanks.

Sample db 'Adventure Works DW' not available in Analysis Services


I have installed SQL Server 2005 with Database Engine and Analysis Services both utilizing the DEFAULT instance. I also installed all the sample databases from the Advanced option.

When I connect to Database Engine, I can see both 'Adventure Works' and 'Adventure Works DW' databases.

When I connect to Analysis Engine, I DO NOT see any databases. I was expecting to see 'Adventure Works DW' .

Thanks in advance for your help :)



adventure works


I just started studying for the mcts 70-432 certification. I purchased the SQL Server 2008- implementation and maintenance training kit. In chapter 1/ lesson 3/ practice 3 the book instructs me to download and install 'AdventureWorks2008' and 'AdventureWorksDW2008'. I'm supposed to go to http://www.codeplex.com/MSFTDBProdSamples, but all I can download are the 2008 R2 versions. Which brings me to my two questions...

1. Will I have any issues with executing code if I have code from a slightly outdated book and a newer version of AdventureWorks?

2. Is the new release (AdventureWorks2008R2) the equivalent of both of the files I am instructed to download (AdventureWorks2008 and AdventureWorksDW2008)?



Adventure works list of customers who has done purchases on a particular date



My requirement is to get a list of customers who has purchased any item on a particular date. If the purchase date is known, how can get the customers for that date who purchased items. An example using the Adventure work analysis database is very much appreciated.



Cannot open adventure-works.com to learn sharepoint 2007 through virtual lab

Actually i am trying to learn sharepoint 2007 through MSDN virtual lab (http://msdn.microsoft.com/en-us/cc707678) and in vitrual lab module 1 it says to go to adventure-works.com to register as new user but when i enter adventure-works.com web page directs me to microsoft.com. Can any body help me to fix this?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend