Editing the installtextserver Script

The installtextserver script is located in the $SYBASE/$SYBASE_FTS/scripts directory. Use a text editor (such as vi or emacs) to open the script, and make your edits. The edits you can make are as follows:

Changing the name of the text_db database. If you use a different name, replace all occurrences of text_db with the appropriate name.

If you change the name of the text_db database, you must change the name in the defaultDb configuration parameter (see “Modifying the Configuration Parameters”).
Changing the name of the Full-Text Search engine. By default, the installtextserver script defines a Full-Text Search engine named “textsvr.” If your Full-Text Search engine is named differently, edit this script so that it defines the correct server name.
Adding multiple Full-Text Search engines (for information on how this can enhance performance, see “Configuring Multiple Full-Text Search Engines”). If you are initially defining more than one Full-Text Search engine, edit the installtextserver script so that it includes all the Full-Text Search engine definitions. installtextserver includes the following section for naming the Full-Text Search engine you are configuring (“textsvr” by default):
```
/*
** Add the text server
*/
exec sp_addserver textsvr,sds,textsvr
go
```
Add an entry for each Full-Text Search engine you are configuring. For example, if you are configuring three Full-Text Search engines named KRAZYKAT, OFFICAPUP, and MOUSE, replace the default “textsvr” line with the following lines:
```
exec sp_addserver KRAZYKAT, sds, KRAZYKAT
exec sp_addserver OFFICAPUP, sds, OFFICAPUP
exec sp_addserver MOUSE, sds, MOUSE
go
```

If you use OmniConnect to communicate with the Full-Text Search engine, change the server name specification in the sp_addobjectdef calls for the vesaux and vesauxcol tables to a valid remote server. For example, if your remote server is named REMOTE, change the lines:

exec sp_addobjectdef "vesaux","SYBASE.master.dbo.vesaux","table"
exec sp_addobjectdef "vesauxcol","SYBASE.master.dbo.vesauxcol", "table"

to:

exec sp_addobjectdef "vesaux","REMOTE.master.dbo.vesaux","table"
exec sp_addobjectdef "vesauxcol","REMOTE.master.dbo.vesauxcol", "table"