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
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
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.
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 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"
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
5. Type in quit and you now have a database ready to
be used for the Guided Tour.