Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Northwind Expand / Collapse
Author
Message
Posted Wednesday, October 23, 2002 8:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 30, 2012 2:03 PM
Points: 142, Visits: 96
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.




Post #7628
Posted Wednesday, October 23, 2002 8:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:13 AM
Points: 1,114, Visits: 6,447
Correct.

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



Clive Strong
clivestrong@btinternet.com
Post #44509
Posted Wednesday, October 23, 2002 8:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
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

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #44510
Posted Wednesday, October 23, 2002 9:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 30, 2012 2:03 PM
Points: 142, Visits: 96
Thanks.




Post #44511
Posted Wednesday, October 23, 2002 9:34 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Tuesday, August 26, 2014 8:57 AM
Points: 8,369, Visits: 736
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)



Post #44512
Posted Thursday, October 24, 2002 5:07 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:13 AM
Points: 1,114, Visits: 6,447
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
Post #44513
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse