Throughout this documentation, examples that use the pubs database are based on the U.S. English version of pubs. Your system must have access to the pubs database to run the sample programs. If you have a localized version of Microsoft® SQL Server™ and want to try the examples, drop the localized version of pubs and install the U.S. English version by running Instpubs.sql. The syntax is as follows:
isql /Usa /Ppassword /Sserver -i\sql\install\instpubs.sql
The pubs database is installed in the \Mssql7\Data directory.