SQL Bible [Electronic resources] نسخه متنی

Installing ACME Database on Microsoft SQL Server 2000 Using OSQL Utility

Following are instructions on how to
install ACME sample database on MS SQL Server 2000 using OSQL utility
(explained in
Appendix
E).

If your MS SQL Server services are not running, start them as
described in
Appendix
D.

Copy the D:\sqlbib\mssql_acme
(where D is the letter of your CD-ROM drive) directory
from the CD-ROM that comes with your book to the
C:\ directory of your computer.

Issue the following commands:

osql /U sa
/P sa /IC:\sqlbib\mssql_acme\create_acme_mssql.sql
/oC:\sqlbib\mssql_acme\create_acme_mssql.log osql /U sa /P sa
/IC:\sqlbib\mssql_acme\load_data_mssql.dat
/oC:\sqlbib\mssql_acme\load_data_mssql.log

This example assumes that during the MS SQL
Server installation you specified password 'sa'
for user
sa (see
Appendix
D). If a different password and user ID were specified, replace values
accordingly. After execution, a log file is created in the specified directory
(in this case
C:\sqlbib\mssql_acme).

Some common errors from running MS SQL
Server scripts are shown in
Table
F-3.