CODEWITHSUNDEEP
sql-serverssmsnorthwind
Roni
Roni

Reputation: 11

Why does the North Wind database not appear in SSMS after running the script?

I copied (copy & past) the script from https://raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/databases/northwind-pubs/instnwnd%20(Azure%20SQL%20Database).sql

to SSMS, ran it, and refreshed the database but the north wind still does not appear.

enter image description here

Upvotes: 0

Views: 1935

Answers (2)

Howard Kohos
Howard Kohos

Reputation: 11

This is what I did to get the correct result:

  1. From Object Explorer right click on "Databases" and select "New Database"
  2. Database Name: enter "Northwind" then press OK
  3. Disconnect and Reconnect Object Explorer with the icons that look like electric plugs -> Northwind DB will be there
  4. From web browser go to https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs and select "instnwnd.sql (currently the second choice)
  5. Select instnwnd.sql, download or click the "RAW" button.
    1. RAW: script is onscreen so you can CTRL+A to select the entire script then CTRL+C to copy to load the script to the clipboard.
    2. Downloaded: Open the instnwnd.sql in a text editor and press CTRL+A to select the entire script then CTRL+C to copy to load the script to the clipboard.
  7. With the script loaded in the clipboard, go back to SQL and right-click on "Northwind" and select "New Query"
  8. In the New Query window, enter CTRL+V to paste the whole script.
  9. From the SQL ribbon select the Execute button.

Screen Captures

Upvotes: 1

Bhargav Chowdary
Bhargav Chowdary

Reputation: 1

The tables are loaded into your current database which you have already created. check in them. If you don't have any database created check in

Databases > System Databases > Master > Tables.

Upvotes: 0

Related Questions