Northwind

  • We can safely drop Northwind, correct? I know it's completely test Db but just want to make sure that Northwind is not of any use.

    Thanks.

  • Correct.

    Both Pubs and Northwind are test db's. You can do with them as you wish.

    Clive Strong

    clivestrong@btinternet.com

  • We have dropped it from our production environment, although we leave it in our test environment, so new programmers can use some of the BOL examples. Also have dropped the PUBS db as well.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • Thanks.

  • It doesn't hurt to make a backup copy of either that you can restore to any server for testing and troubleshooting issues that seem to only occurr on one server or another.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Or failing to back it up, you can re-create the Northwind DB for future use.

    From the command line go into the mssql\install directory and run the following...

    osql/Usa /Psapassword /Sservername /iinstnwnd.sql /oinstnwnd.rpt

    the file instnwnd.rpt will contain errors (if there are any).

    Clive Strong

    clivestrong@btinternet.com

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply