Thursday, May 28, 2015
The Northwind sample database is probably the most mention sample database of all time. Most of the tutorials on the web uses the Northwind sample database as an example. However, it's not as straight forward to add the Northwind database to your SQL Server instance as you may have think. The reason is because the Northwind database was initially created for SQL Server 2000. Therefore, most of the newer versions of SQL Server will throw an error when you tried to attach the .mdb file. It is easier to run the SQL script that is provided with the download. In this blog we will go over where to download the Northwind sample database, and how to add to your SQL Server instance using the SQL script.
1. Open your browser and type in the following URL in the address bar
https://www.microsoft.com/en-us/download/details.aspx?id=23654
2. Click on the "Download" button
3. Save the SQL2000SampleDb.msi file to a location that you will remember in your PC
4. Double click on the SQL2000SampleDb.msi file, click "Next" on the welcome screen
5. Accept the license agreement, then click "Next"
6. Select "Entire feature will be installed on local hard drive" and click "Next" on the "Choose Installation Options" step.
7. Click "Next" on the "Confirm Installation" screen
8. Click "Close" on the "Installation Complete" screen. To complete the installation
9. Up to this point we've only installed the Northwind sample database data and script files on our PC, the actual database has not been created in our SQL Server database instance. The files are stored in the folder C:\SQL Server 2000 Sample Databases
10. To create the Northwind database in our SQL Server database instance open the SQL Server Management Studio, and connect to your SQL Server instance.
11. Right-click on the "Databases" node and select "New Database"
12. On the "New Database" screen type "Northwind" in the Database Name: field, then click "OK"
13. Now an empty "Northwind" database has been created
14. Right-click on the "Northwind" database and select "New Query"
15. A new query window is opened for the Northwind Database
16. Open the file instnwnd.sql in the C:\SQL Server 2000 Sample Databases folder, then copy the table creation and seed data part of the script. Since, we are running the script on our empty Northwind database we don't have to worry about the database creation part of the script. Just one less thing to worry about. Copy the contents in the northwind-create-table-seed.txt file into the SQL Query window in step 15.
17. Click on the "Execute" button to run the script
18. After the script has been run successfully you will get the message that the query has been executed successfully in the results window.
19. The Northwind database is now added to SQL Server with all the stored procedures and views in it.
1. Open your browser and type in the following URL in the address bar
https://www.microsoft.com/en-us/download/details.aspx?id=23654
2. Click on the "Download" button
3. Save the SQL2000SampleDb.msi file to a location that you will remember in your PC
4. Double click on the SQL2000SampleDb.msi file, click "Next" on the welcome screen
5. Accept the license agreement, then click "Next"
6. Select "Entire feature will be installed on local hard drive" and click "Next" on the "Choose Installation Options" step.
7. Click "Next" on the "Confirm Installation" screen
8. Click "Close" on the "Installation Complete" screen. To complete the installation
9. Up to this point we've only installed the Northwind sample database data and script files on our PC, the actual database has not been created in our SQL Server database instance. The files are stored in the folder C:\SQL Server 2000 Sample Databases
10. To create the Northwind database in our SQL Server database instance open the SQL Server Management Studio, and connect to your SQL Server instance.
11. Right-click on the "Databases" node and select "New Database"
12. On the "New Database" screen type "Northwind" in the Database Name: field, then click "OK"
13. Now an empty "Northwind" database has been created
14. Right-click on the "Northwind" database and select "New Query"
15. A new query window is opened for the Northwind Database
17. Click on the "Execute" button to run the script
18. After the script has been run successfully you will get the message that the query has been executed successfully in the results window.
19. The Northwind database is now added to SQL Server with all the stored procedures and views in it.
Subscribe to:
Post Comments (Atom)
Excellent read, Positive site, where did u come up with the information on this posting? I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work.
ReplyDeleteRead more
Whether you choose to play in Windsor or Fallsview Niagara Falls , or with a view of ... Casino Rama offers everything you'll need for a great stay.
DeleteAny bad thread or process can cause such an appropriate action with ease, even SQLite library can't help you in this situation.kpi dashboards
ReplyDeleteĐặt vé tại phòng vé Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ Vietnam Airline
chuyến bay mỹ về việt nam
vé máy bay từ nhật về vn
mua vé máy bay từ đức về việt nam
các đường bay từ canada về việt nam
mua vé máy bay từ hàn quốc về việt nam
Chuyen bay cho chuyen gia nuoc ngoai
LEGIT FULLZ & TOOLS STORE
ReplyDeleteHello to All !
We are offering all types of tools & Fullz on discounted price.
If you are in search of anything regarding fullz, tools, tutorials, Hack Pack, etc
Feel Free to contact
***CONTACT 24/7***
**Telegram > @leadsupplier
**ICQ > 752822040
**Skype > Peeterhacks
**Wicker me > peeterhacks
"SSN LEADS/FULLZ AVAILABLE"
"TOOLS & TUTORIALS AVAILABLE FOR HACKING, SPAMMING,
CARDING, CASHOUT, CLONING, SCRIPTING ETC"
**************************************
"Fresh Spammed SSN Fullz info included"
>>SSN FULLZ with complete info
>>CC With CVV (vbv & non vbv) Fullz USA
>>FULLZ FOR SBA, PUA & TAX RETURN FILLING
>>USA I.D Photos Front & Back
>>High Credit Score fullz (700+ Scores)
>>DL number, Employee Details, Bank Details Included
>>Complete Premium Info with Relative Info
***************************************
COMPLETE GUIDE FOR TUTORIALS & TOOLS
"SPAMMING" "HACKING" "CARDING" "CASH OUT"
"KALI LINUX" "BLOCKCHAIN BLUE PRINTS" "SCRIPTING"
"FRAUD BIBLE"
"TOOLS & TUTORIALS LIST"
=>Ethical Hacking Ebooks, Tools & Tutorials
=>Bitcoin Hacking
=>Kali Linux
=>Fraud Bible
=>RAT
=>Keylogger & Keystroke Logger
=>WhatsApp Hacking & Hacked Version of WhatsApp
=>Facebook & Google Hacking
=>Bitcoin Flasher
=>SQL Injector
=>Premium Logs (PayPal/Amazon/Coinbase/Netflix/FedEx/Banks)
=>Bitcoin Cracker
=>SMTP Linux Root
=>Shell Scripting
=>DUMPS with pins track 1 and 2 with & without pin
=>SMTP's, Safe Socks, Rdp's brute
=>PHP mailer
=>SMS Sender & Email Blaster
=>Cpanel
=>Server I.P's & Proxies
=>Viruses & VPN's
=>HQ Email Combo (Gmail, Yahoo, Hotmail, MSN, AOL, etc.)
*Serious buyers will always welcome
*Price will be reduce in bulk order
*Discount offers will give to serious buyers
*Hope we do a great business together
===>Contact 24/7<===
==>Telegram > @leadsupplier
==>ICQ > 752822040
==>Skype > Peeterhacks
==>Wicker me > peeterhacks
this data base for mysql, oracle sql server and postgresql found here northwind db
ReplyDelete