Wednesday, December 2, 2009

ADO.NET studies and AdventureWorks DB

After setting up SQL Server 2008 Express Edition and the Microsoft SQL Server Management Studio, I went to download the AdventureWorks sample database.

Apparently, AdventureWorks is the new sample database, taking the place of the classic Northwind sample database. Downloaded it from the following site:

Microsoft SQL Server Product Samples: Database - Release SQL Server 2008 SR3

This turned out to be much more painful than expected, mainly because the AdventureWorks DB requires both Full Text Search and FileStream.

Here are the Prereqs for the AdventureWorks DB.

Unfortunately, I installed the DB Runtime with SSMS only (no Advanced Services).

I'm going to uninstall the SQL Server 2008 instance and install the version that includes:
  • DB Runtime
  • SSMS
  • Advanced Services

No comments:

Post a Comment