You can add Full-Text Search engines at a later date by issuing the sp_addserver command from isql. The sp_addserver command has the following syntax:
sp_addserver server_name [, server_class [, physical_name]]
where:
server_name is the name used to address the server on your system (in this case, the Full-Text Search engine).
server_class identifies the category of server being added. For the Full-Text Search engine, the value is “sds”.
physical_name is the name in the interfaces file used by the server server_name.
For more information, see sp_addserver in the Adaptive Server Reference Manual.
For example, to add a Full-Text Search engine named BLUE, enter:
sp_addserver BLUE, sds, BLUE
After you configure and start the Full-Text Search engine, you can use the following syntax to see if you can connect to the Full-Text Search engine from the Adaptive Server:
server_name...sp_show_text_online
For example, to connect to a server named BLUE, enter:
BLUE...sp_show_text_online
