Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

pubs Sample Database

SQL Server 2000

The pubs sample database is modeled after a book publishing company and is used to demonstrate many of the options available for a Microsoft® SQL Server™ database. The database and its tables are commonly used in the examples presented in the documentation content.

If you have made changes to the pubs database, you can reinstall it using files located in the Install directory of your SQL Server installation. The installation process requires two steps:

  1. From the command prompt, use the osql utility to run the Instpubs.sql script. This drops the existing pubs database, creates a new one, and defines all the objects in the database.

  2. From the command prompt, run Pubimage.bat. This inserts image values into the pub_info table.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft