We are running sybase 4.9.1 on HP-UX A09.04.
A couple of time a year we run in the situation that
tempdb is filled up with temporary tables.
(Probably the tables created with select into #...)
As far as I know, the only way to recover from this situation
is restarting the sybase server.
Does anybody know if there is a way to prevent the tempdb
from filling up? If not, is there a way to correct the situation