Fix the Northwind Sample Database, regardless of which version of SQL Server is used

Northwind database

Here we can find a breakthrough:

 

Http://social.msdn.microsoft.com/Forums/zh-CN/Vsexpressvb/thread/8490a1c6-9018-40c9-aafb-df9f79d29cde

 

The following is MSDN:

Http://msdn2.microsoft.com/en-us/library/ms227484 (VS.80). aspx

 

Here is the Access version:

Http://www.microsoft.com/downloads/details.aspx? FamilyID = C6661372-8DBE-422B-8676-C632D66C529C & displaylang = EN

Here is the installation package of SQL 2000 (the installation package contains xuanjicang and Haidong ).

Http://www.microsoft.com/downloads/details.aspx? Familyid = 06616212-0356-46a0-8da2-eebc53a68034 & displaylang = en

Download SQL2000SampleDb. msi and use the following command to extract the content:

Msiexec.exe/a "C: \ Documents ents and Settings \ Hello \ Desktop \ DBSQL2000SampleDb. msi"/qb targetdir = "C: \ Documents ents and Settings \ Hello \ Desktop \ DB \ SQL2000SampleDb"

The rest is your own play:

 

Instnwnd. SQL
Instpubs. SQL
NORTHWND. LDF
NORTHWND. MDF
PUBS. MDF
PUBS_LOG.LDF
ReadMe_SQL2000SampleDbScripts.htm

 

You can directly attach a database of version 2000 to a later engine.

Even if it doesn't work, we don't have all the scripts for creating a database. Haha.