In ASE 12.5.3 (at least), sort-merge joins are disabled by default.
Anyone know the reason why (beyond mere conjecture)?
Thanks,
--Jeff

I encountered today a case of one process being blocked by another one
which doesn't exist (sp_who showed process B blocked by spid 8, spid 8
doesn't exist).
How did this occur?   How can it be resolved (can't kill spid 8

When I try to connect to the database from the server, like the
fallowing lines, I have Errors, But when I connect from others servers
it's OK. The errorlog doesn't  show erros. It's a sybase 11 with AIX.
-------------------------------------------------------------

I know that the hex format is generally a PITA and that there are perl
scripts to decode it into human-readable form but I actually need a
script that goes the other way, believe it or not. I have been seeing
syslog errors like this one:

I need to set audit in Sybase for some users only.  How can I setup
audit for a database and a user on delete, truncate etc
The following commands do it for the database entire users which I
don't want to do

I have a question  - when i do a select @@servername as SA returns
NULL
how can i see to which server I'm logged into?
isql -Usa -Pabc1234

I have a user that does not kow the passord for the database anymore,
i have tried sp_password  as sa and doed not work because I dont know
the callers password, how can i change it?
Many thanks

Can anyone tell me what the performance hit for INSERTs would be if I
implemented this on a permanent table