Installing Northwind on SqlExpress

re: Installing Northwind on SqlExpress

euanga — Wed, 02 Nov 2005 20:14:24 GMT

You should really be using SQLCMD not osql.

re: Installing Northwind on SqlExpress

Bill Burrows [MVP] — Thu, 03 Nov 2005 01:09:32 GMT

Hi Steve,

Thanks for the information. May I suggest that this information be placed somewhere fairly obvious on the SQL Express home site. My guess is many people downloading SQL Express will want a database to play with.

bill

re: Installing Northwind on SqlExpress

Rob Windsor — Fri, 04 Nov 2005 02:21:47 GMT

You use the wrong slash in step 5:

computerName/SqlExpress should be computerName\SqlExpress

re: Installing Northwind on SqlExpress

Ka — Wed, 23 Nov 2005 04:31:55 GMT

osql -E -S computerName/SqlExpress -i instnwnd.sql

should be

osql -E -S computerName\SqlExpress -i instnwnd.sql

re: Installing Northwind on SqlExpress

enoreth — Wed, 11 Jan 2006 15:08:14 GMT

thanks i installed successfully the northwind
but the problem is it was installed under the databasename "master". Any suggestions?

re: Installing Northwind on SqlExpress -> Thank you!

Trevor Carnahan — Tue, 17 Jan 2006 09:15:04 GMT

I appreciate you putting this up. It was the first hit in my "how install northwind sqlexpress" google search, and it was exactly what I was looking for. Thanks again.

re: Installing Northwind on SqlExpress

Thang — Sun, 22 Jan 2006 19:40:40 GMT

Using SQL Server Management Studio, you can use the Attach... function.

In the SQL Mgt Studio:
- Right click on Databases node, select Attach ... - a Attach DBs dialog popups.
- Click on the Add button on the dialog
- Navigate to the location where you extract the database (northwind or pubs) and select the *.MDF file ( you can add more than one DB)
- Click OK to complete it.

You should see the new DB in the list under Databases node.

re: Installing Northwind on SqlExpress

Edgardo — Fri, 27 Jan 2006 09:20:05 GMT

Excellent!

Thanks

re: Installing Northwind on SqlExpress

dave — Wed, 01 Mar 2006 17:04:37 GMT

step 1 says to lick the download button:) but everything else works, thanks

re: Installing Northwind on SqlExpress

DeveloperDan — Tue, 21 Mar 2006 13:22:35 GMT

Everything else works? Nothing works for me after I lick the download button. I hate computers!

re: Installing Northwind on SqlExpress

LFN — Sat, 20 May 2006 01:56:49 GMT

Simply thank you.

re: Installing Northwind on SqlExpress

Mick — Wed, 24 May 2006 10:52:38 GMT

Thanks for the post very useful, now get my express up and running

re: Installing Northwind on SqlExpress

Yogesh Ramakrishnan - Proapp Systems — Thu, 10 Aug 2006 05:54:31 GMT

Thanks a lot, this saved a lot of my time. I had a an important demo with one of my clients. Thanks again.

re: Installing Northwind on SqlExpress

DB — Thu, 17 Aug 2006 12:21:42 GMT

osql didn't work here, but
sqlcmd -E -S computerName\SqlExpress -i instnwnd.sql
did the job.

re: Installing Northwind on SqlExpress

William M. Rawls — Tue, 29 Aug 2006 15:25:36 GMT

Maybe this is just too obvious, but why not just provide the SQL Express version of the Northwind file directly intead ?

Installing Northwind on SqlExpress2005

Katsan Love .Net Blog! — Tue, 12 Sep 2006 19:53:20 GMT

Northwidn Sample Data for SQLExpress

TangibleThoughts — Tue, 12 Dec 2006 12:35:46 GMT

Heres a post by Steve Stein that gives you a 5 step instruction guide to install Northwind db on SQLExpress....

re: Installing Northwind on SqlExpress

NewSQLProgrammer — Thu, 05 Jul 2007 17:54:50 GMT

Excellent Steve!!!!!!!

Thanks

re: Installing Northwind on SqlExpress

bill — Fri, 03 Aug 2007 23:36:11 GMT

need it for the sql server 2005

sshlog » Blog Archive » [SQL] SQLExpress 2005 ?????? ???????????????

Wed, 19 Nov 2008 06:32:39 GMT

PingBack from http://blog.ssh.tw/?p=1247

Funky » the new dooz

Funky » the new dooz — Tue, 24 Feb 2009 21:12:37 GMT

PingBack from http://www.dooz.se/blog/?p=270

Smart Client Data Installing Northwind on SqlExpress | Toe Nail Fungus

Smart Client Data Installing Northwind on SqlExpress | Toe Nail Fungus — Tue, 09 Jun 2009 09:11:00 GMT

PingBack from http://toenailfungusite.info/story.php?id=5226

Smart Client Data Installing Northwind on SqlExpress | bar stools

Smart Client Data Installing Northwind on SqlExpress | bar stools — Sun, 14 Jun 2009 08:49:22 GMT

PingBack from http://barstoolsite.info/story.php?id=6550