Pubs database for MSDE

I installed MSDE2000 on my Win XP Pro computer to run
through examples in a book. Some of the examples uses the
Pubs database which I cannot find in my MSDE setup. How
can I setup the Pubs database in my setup and where can I
download it from? Thanks.
We have just made a file available in the Microsoft Download Center that
contains scripts for creating the pubs and Northwind sample databases.
Go to http://www.microsoft.com/downloads
Select SQL Server as the Product and enter sample databases in the Keywords
field and click Go. You will see an entry for Sample Databases.
The direct link is:
http://www.microsoft.com/downloads/d...DisplayLang=en
From the download file readme:
These copies of the scripts are the same as the versions included with SQL
Server 2000, except for these changes:
a.. The script for creating pubs, instpubs.sql, has been modified to
install pubs and all of the pubs data in one step. The version of
instpubs.sql included in SQL Server 2000 does not load in some of the pubs
data, customers had to run batch jobs to install some of the larger data
values.
b.. The scripts improve security by not creating a guest account and not
assigning permissions to the objects in the sample databases. Customers who
install the sample databases can now control access to the sample databases.
SQL Server 2000 Desktop Engine (MSDE 2000) customers can also use these
copies of the scripts to install pubs and Northwind.
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights