Search code examples
sql-serverdatabasenorthwind

How to view installed Northwind database?

I have installed a sample database, specifically Northwind from http://msdn.microsoft.com/en-us/library/8b6y4c7s.aspx.

After installing the .msi file, I dont see any Northwind database in my local sql express server when using SQL Server management studio. Am i missing a step? Do i have to run some script?

Solution

  • From the download page:

    After downloading SQL2000SampleDb.msi, extract the sample database scripts by 
double-clicking SQL2000SampleDb.msi. SQL2000SampleDb.msi will extract the 
database scripts and this readme file into this 
default folder:

C:\SQL Server 2000 Sample Databases

    So it seems to me you have to go to that folder and execute the SQL files installed there for the database to be created.