SQL Server 2005 Express Edition

SQL Express is essentially the new MSDE. In other words, it is a free and "lite" version of the next generation of SQL Server, formerly known as "SQL Server Yukon". You can enjoy all of the core functionality of the latest SQL Server engine. Only the enterprise features are removed.

For the purposes of this Guided Tour, SQL Express and VWD have tight integration for data dependency caching that doesn't exist in SQL Server 7.x and SQL Server 2000.  Otherwise, all database related discussions through the Guided Tour//指导手册中讨论的相关数据库 are identical//相同的for all versions of SQL Server.

Setting Up Your Database

The steps within this section are assuming//设想 that you are using SQL Express as your database server.

The Guided Tour uses the pubs database //数据库名that ships with //附带SQL Server 2000.  However, SQL Express does not ship with //附带any test databases.  The script //脚本to install the pubs database //数据库名has been included as part of the Guided Tour.

By default SQL Express installs as a SQL instance called SqlExpress that uses integrated security.  The installer assumes//设想 that the account running the pubs database //数据库名installation script// 安装脚体is the same account that installed VWD and SQL Express. Of course, this account must also have administrative permissions//管理员权限.

Throughout the Guided Tour you will see references to "machine-name" and the username used in the demo//样例.  Be certain to change all references of "machine-name" to your machine name, and username to your username.

1.  Download the script for the pubs database and save it to your desktop.

Assuming//假设 that you have performed //完成a typical install of SQL Express on your C: drive, the command line tool //命令行工具that you need to use to install the downloaded SQL script //下载下来的SQL脚体is located at C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.

2. Navigate to Start | Run. In the Open field, paste the following command, modify it for your machine name (or "localhost"), and then click OK:

"C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD" -S "machine-name\SqlExpress"//注意引号也要复制进去，且把这里的＂machine-name"换成＂localhost＂或自己的计算机名，如我的计算机名就是＂hl004＂

3.  Using Notepad, open the pubs installation script and select the contents (Ctrl+A).  Copy the contents by pressing Ctrl+C. You will be pasting these contents into the command line application.

4. In the command line utility right-click and select Paste.  The script will then be executed and the pubs database will be created.

5.  Type in quit and you now have a database ready to be used for the Guided Tour.