If your tempdb gets full you can do one of following:
you can expand your tempdb or you can use
select lct_admin(0,2)
go
It will abort all open transactions.But be sure the task by
confirming with the concern users.
Restarting the server is not recommanded.
lct_admin (0,2) would abort all open transactions, or you
can go for altering the tempdb space. Multiple tempdb's is
a feature which can be implemented to minimize such issues
of tempdb getting full.
In sybase, we can have multiple users associated to same
login ,each corresponds to different databases, right? how
can we login to one database with corresponding user id?