<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server Newbies
»
Northwind Database for SQL Server 2005
Northwind Database for SQL Server 2005
Rate Topic
Display Mode
Topic Options
Author
Message
jrichards54
jrichards54
Posted Tuesday, September 18, 2012 11:26 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, December 18, 2012 4:35 PM
Points: 57,
Visits: 107
Hello to all. This is my first post in this forum so I guess I am a "Grasshopper" again. I don't mind being a "Grasshopper" if I can just learn to use SQL Server 2005.
I just yesterday managed to make a connection to the SQL Server with some very fine assistance by a few MS MVP's (In another Forum) but the ADO.NET 2.0, Microsoft Press, author Rebecca M. Riordan uses the Northwind and the Pubs databases in the exercises throughout the book so I need to add these two databases to the Server so that I can continue my study of this very fine text. I have the Northwind Database in my Microsoft Access but I do not want to try to create such a hugh database in the SQL Server on my own. I have created two of the Tables to the Pubs DB and it was quite a bit of work and subject to my errors. MS furnishes text so that I can build these two databases in my SQL Server but that is a hugh task for this newbie. Any suggestions on how or where I can download the databases and add them to the Server? Thank you and have a good day. JRichards54
Post #1360915
Luis Cazares
Luis Cazares
Posted Tuesday, September 18, 2012 11:37 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 5:27 PM
Points: 1,086,
Visits: 2,190
Have you tried to google them?
The first result when I searched Northwind was
https://www.microsoft.com/en-us/download/details.aspx?id=23654
It might be different for you since I'm using DuckDuckGo
Luis C.
Please don't trust me, test the solutions I give you before using them.
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1360920
jrichards54
jrichards54
Posted Thursday, September 20, 2012 9:58 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, December 18, 2012 4:35 PM
Points: 57,
Visits: 107
Luis Cazares (9/18/2012)
Have you tried to google them?
The first result when I searched Northwind was
https://www.microsoft.com/en-us/download/details.aspx?id=23654
It might be different for you since I'm using DuckDuckGo
Mil gracias, senor Cazares.
I printed "Northwind Database Installation" and "Installing the Northwind Sample Database", both from Microsoft webpages. I just noticed that the latter is for VS 2012 and I need to go back and click on "Other Versions" to get specific instructions on how to install to SQL Server 2005 Developer Edition.
But I have spent over 2 weeks getting a connection to my Server and it has the Adventureworks DB available and the MS Book (Microsoft SQL
Server 2005 Implementation and Maintenance) that I am studying uses that DB in their exercises. Right now I want to continue my studies in this text and I will get back to installing the Northwind DB when I am ready to study "Microsoft ADO.NET 2.0".
BTW, I am not fluent in Spanish. I know about 9000 words but I do not converse well, everyone (even 6 year old children) know more Spanish than I do. He estudiado mucho pero aprendido un poco. Thanks again. JRichards54
Post #1362110
Luis Cazares
Luis Cazares
Posted Thursday, September 20, 2012 11:01 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 5:27 PM
Points: 1,086,
Visits: 2,190
The instructions are mostly generic as VS 2012 is independent of SQL Server.
You can follow the instructions here:
http://www.codeproject.com/Articles/20987/HowTo-Install-the-Northwind-and-Pubs-Sample-Databa
if you don't feel confident to use the SQL Script files (.sql).
I hope you have less problems than the ones you had installing SQL Server.
I wonder how did you know that I'm a native spanish speaker (maybe my accent
) as there's no information of that on my profile. BTW, 9000 words is a great vocabulary for someone who "has learned just a few".
Luis C.
Please don't trust me, test the solutions I give you before using them.
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1362168
jrichards54
jrichards54
Posted Saturday, September 22, 2012 5:04 PM
Valued Member
Group: General Forum Members
Last Login: Tuesday, December 18, 2012 4:35 PM
Points: 57,
Visits: 107
Luis Cazares (9/20/2012)
The instructions are mostly generic as VS 2012 is independent of SQL Server.
You can follow the instructions here:
http://www.codeproject.com/Articles/20987/HowTo-Install-the-Northwind-and-Pubs-Sample-Databa
if you don't feel confident to use the SQL Script files (.sql).
I hope you have less problems than the ones you had installing SQL Server.
I wonder how did you know that I'm a native spanish speaker (maybe my accent
) as there's no information of that on my profile. BTW, 9000 words is a great vocabulary for someone who "has learned just a few".
Sir, I knew by your name being posted at the very top after [quote]. Also, you included a couple of lines at the bottom that were in Spanish.
Yes, I certainly have had more success installing the Northwind and pubs databases. I ran the SQL Script files (.sql) from my VS 2005 Query Editor and when I clicked on "Execute" there it was. I then ran it again for the other one and both are now in my Server along with the Adventureworks and the System Databases (which I do not mess with).
Thank you for the help and the comments. Have a good day. JRichards54
Post #1363179
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
