Do you guys shutdown & restart ASE server periodically?
Is there any document or statistics mentioning about periodically restarting
ASE server for maintanance?
My boss wants me to do so weekly.

I need some comand to debug several store procedure in sybase 12.5  
and some examples how to use it !
could somebody help me please  ??
Many thanks in advantage.

Sybase 12.5.1 for Solaris.
I am trying to create a table with 40 fields, some are int and some are
varchar.
But I'm getting this error message:

I'm trying to dynamically allocate memory (on the heap) to store data I
retrieve from a Sybase database.  Now I have code that uses stack memory and
looks like:
exec sql begin declare section

I'm developing a vb application ;
Me (at client side): Win XP and Office XP
database           : sybase 11.9.2 on win 2k
server             : win2k

I have a Sun Java Station W1100 running Solaris 9.0 and Java Desktop.
j2sdk1.4.
The install shield program says "searching for java virtual machine" and
then stops. Never comes up.

Is there a short-cut to update statistics of all tables because my
databases contain a lot of tables.

We have backup file from our customer that their Sybase is installed
on Unix. We have Sybase installed on Windows, can we install from
their Sybase backup.
Rao

has anyone some howto/doc on good default security for sybase ase ?
(setup is unix, mostly linux)
for example
setting user with access on only some db with some limited rights, limit

I'd be grateful if you help me with the following problem:
I'm trying to install ASE 12.5.1 on Linux (the free version). I
downloaded the package (.tar.gz). Then I unpacked it, created user
sybase and group sybase which the user sybase belongs to. I added user

Please explain -
1>use master
2>go
1> select db_name(0)

I have read somewhere that from ASE 12.0 onwards the way ASE locks tempdb
system tables when a 'select into' operation is performed has changed such
the locks are only held for the duration of the table creation and not the
full operation. I've always been under the impression ...

I am trying to get the output of a stored procedure to a table (using
SQL in ASE 12.5).  I have seen some posts that say you can do this
using create existing table, however it complains that my server "does
not have PASSTHRU or RPC capabilities", from what I read I had to use

By default, the ASE listens at one address (ip, port).
Is it possible to have the ASE listen to multiple addresses?
Thanks,
Ashish

Could anyone know how can I check which stored procedure is running?
Peter