Eat Sleep and Code

At my day job, we use Sybase for our database servers. From time to time, I have to reload databases from saved dumps for development environments. This can sometimes be a pain when people have forgotten to log out from the database (especially after they've all gone home :) ). I did some quick research and figured out that (with the appropriate privileges) you can kill off the offending processes.

First, find the offending process by listing connections using sp_who.

Then, select the process that you need to kill off and do so by using the kill command

kill <spid>

It's straightforward and obvious, but quite helpful for those cases when I need it.

ref: Sybase Manual