Filter
Top Products
CHAPTER 1 Installing Adaptive Server
25
For more information on
sp_syntax, see the Reference Manual. This script
includes syntax information for Transact-SQL, the system procedures, and the
Sybase utilities. When you execute this script, you install the SQL portion of
the
sybsyntax database.
When you first execute this script, it creates the
sybsyntax database and the
necessary tables and indexes. If you execute the script again, the previously
installed rows of information are deleted from the table in the database and then
reinstalled.
Default device for the sybsyntax database
By default, the sybsyntax script installs the sybsyntax database on the device
that is designated as the default database device.
If you have not changed the status of the master device (which is installed as
the default disk) or specified another default device, the script automatically
installs
sybsyntax on the master device. Sybase does not recommend this
configuration because
sybsyntax uses valuable space that is best left available
for future expansion of the
master database.
To avoid installing
sybsyntax on the master device, do one of the following:
•Us
sp_diskdefault to specify a default device other than the master device.
For information about
sp_diskdefault, see the Reference Manual.
• Modify each sybsyntax installation script that you plan to execute to
specify a different device, as explained in the following section.
Installing sybsyntax
For each sybsyntax installation script you want to execute:
• Determine the device location where you plan to store the
sybsyntax
database.
• Make a copy of the original script. Be sure you can access this copy, in
case you experience problems with the edited script.
• Use a text editor to edit the script, if necessary, to change the default device
from the master device to a new default device.
• Comment out the following section, which specifies the default device:
/*create the database, if it does not exist */