use master
go
3. Create a database named hq. Inthis example, we use a 5 MB database
witha 5 Mb log, on two different devices:
create database hq
on database_device = 5
log on log_device = 5
go
☞Formore information on how to create databases and assign space to
them,see your Adaptive Server Enterprise documentation.
InstallSQL Remote Youneed to install SQL Remote into the hq database.
❖Toinstall SQL Remote into the hq database
1. If the system administrator login name you are using does not have the
hqdatabase as the default database, make a backup copy of the
ssremote.sql
scriptfrom your installation directory, and add the following
twolines to the beginning of the script:
use hq
go
2. Change to the tutorial directory. Then, using
isql
,connect to the server
usingthe hq database, and run the
ssremote.sql
scriptfrom your
SQLRemote installation directory. The following command should be
enteredall 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
hqdatabase as the default database, make a backup copy of the
stableq.sql
scriptfrom your installation directory, and add the following
twolines 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
scriptfrom your SQL Remote installation directory. The
followingcommand should be entered all on one line:
isql -S server-name -U sa -P sysadmin -I stableq.sql
Createdirector ies for
messages Createa directory to hold the files from this tutorial. Forexample:
mkdir c:\tutorial
58