views:

324

answers:

3

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?

+1  A: 

you don't mention which msi file, but most of them seem to relate to a sample database.

Which database software are you using?

Daniel P
+4  A: 

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.

Vinko Vrsalovic
Awesome! thanks a lot! :)
burnt1ce
MrTelly
+1  A: 

From the download page on the page you linked to:

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

I didn't download it to see what gets extracted, but I'm betting there's a script or two that you can run to create the database. Probably a *.sql, that you can open and run in a query window.

EDIT: I just downloaded and extracted. It looks like all you need to do is execute the contents of instnwnd.sql (which should be in C:\SQL Server 2000 Sample Databases). Open a new query window (in SSMS etc.), load the file, and press F5.

Matt
Hey, don't plagiarize the answers! ;-)
Vinko Vrsalovic
@Vinko - Um, great minds think alike? ;-)
Matt
Thanks! Vinko beat you to it though.
burnt1ce