When you do not have the row in sysprocesses but you do have in
syslocks that is zombie lock ( i.e. phantom lock )
You will need to either recycle ASE server or use dbcc . If you are
using ASE 12.5.4 or later version , you can try using 'dbcc
A phantom [lock] is when there is an entry in syslocks for
a spid, but the spid does not exist in sysobjects (phantoms
have no body, just cast a shadow). Phantom locks are usually
due to bugs in process cleanup in the ASE.