User's Manual

use master
go
3. Create a database named hq. In this example, we use a 5 MB database
with a 5 Mb log, on two different devices:
create database hq
on database_device = 5
log on log_device = 5
go
☞ For more information on how to create databases and assign space to
them, see your Adaptive Server Enterprise documentation.
Install SQL Remote You need to install SQL Remote into the hq database.
❖ To install SQL Remote into the hq database
1. If the system administrator login name you are using does not have the
hq database as the default database, make a backup copy of the
ssremote.sql script from your installation directory, and add the following
two lines to the beginning of the script:
use hq
go
2. Change to the tutorial directory. Then, using isql , connect to the server
using the hq database, and run the ssremote.sql script from your
SQL Remote installation directory. The following command should be
entered all on one line:
isql -S server-name -U sa -P sysadmin -I ssremote.sql
3. If the system administrator login name you are using does not have the
hq database as the default database, make a backup copy of the
stableq.sql script from your installation directory, and add the following
two lines to the beginning of the script:
use hq
go
4. Using isql , connect to the server using the hq database, and run the
stableq.sql script from your SQL Remote installation directory. The
following command should be entered all on one line:
isql -S server-name -U sa -P sysadmin -I stableq.sql
Create directories for
messages
Create a directory to hold the files from this tutorial. For example:
mkdir c:\tutorial
58