Sybase DC38133-01-0902-01 manual To install SQL Remote into the hq database

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 Create a directory to hold the files from this tutorial. For example:

messages

mkdir c:ntutorial

58