October 23, 2002 at 8:19 am
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.
October 23, 2002 at 8:21 am
Correct.
Both Pubs and Northwind are test db's. You can do with them as you wish.
Clive Strong
October 23, 2002 at 8:39 am
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
October 23, 2002 at 9:13 am
Thanks.
October 23, 2002 at 9:34 am
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)
October 24, 2002 at 5:07 am
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply