SQL Remote User's Guide
A Tutorial for Adaptive Server Enterprise Users
Tutorial: Adaptive Server Enterprise replication
Setting up the consolidated database
In this tutorial, messages are exchanged using the shared file link. You must create a FILE message type supplying the address of the consolidated database publisher.
To create the message type
Execute the sp_remote_type stored procedure, using HQ as the address of the consolidated database publisher:
sp_remote_type file, hq go
The address (hq) for a file link is a directory in which files containing the message are placed. It is taken relative to the SQLRemote environment variable or registry entry. As you have not set this value, the address is taken relative to the directory from which the Message Agent is run. You should run the Message Agent from your tutorial directory for the addresses to be interpreted properly.
For information about setting the SQLRemote value, see Setting message type control parameters.
With the message type defined, you can now make the necessary users.