how to view the current connections in sybase and kill one of them?thanks

"jakey chen" <jakey_515 (AT) 163 (DOT) net> wrote



Run sp_who to get a list of all current sessions. To kill a session,
run:

kill <spid>
go

.... where <spid> is the session number shown by sp_who.


HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------