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.