Sybase ADDICT

Hello,

A quick way to list all ASE’s configuration parameters having values different than “default value”, is to log into isql as “sa”, and run this query:

1> sp_configure "display"
2> go

Hope this helps…

In some situations, you might need to force EBF installation. In order to do that, you will have to setup INSTALL_ALL_PATCH variable.

On Unix do:

export INSTALL_ALL_PATCH=1

On Windows do:

set INSTALL_ALL_PATCH=1

Then you can start EBF installation (console mode here):

setup -console

You just have to run a simple query in isql to find all the reserved words for Adaptive Server Enterprise and Sybase SQL Server. To list all reserved words for Adaptive Server Enterprise, log in to isql and run this query:

1> select name from spt_values where type = "W"
2> go


The spt_values table is a look-up table in the master database that stores system values used by other server processes.