title: How do I kill an unruly spid in Sybase?
body: <p>I've got a couple of rogue spid's in my database that I can see are sleeping when I log in as <code>sa</code> and use <code>sp_who</code>, but attempts to use <code>kill &lt;spid&gt;</code> to eliminate them have failed and I don't actually have access to the server itself to bounce it. Is there any other way of killing these things off?</p>