@Brett : yes, I select @@spid, and log it in text log file with a code : batch/interactive session.

@Alun :
I sometime have batch session that are freezed (mostly while attempting FTP transfers).
So i need to kill these freezed sessions using SQL managment sudio.

If the freezed session is automatically relased by the windows task scheduler (do not run more than x minutes) , the spid of the freezed session is re-used by SQLSERVER.
Since spids are re-used, i will kill a session that is NOT freezed....

No way to tell SQLSERVER to NOT re-use an spid, or to define a spid cycle ???

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.