web analytics

Sybase simplified sp_who procedure

The procedure displays only the necessary fields from sysprocesses:

create procedure sp_who_all as select PR.spid , PR.fid , substring(suser_name(PR.suid),1,10) Login_name, substring(PR.program_name,1,10) Program , PR.status , cmd , substring(db_name(dbid),1,19) db_name, substring(tran_name,1,22) tran_name, blocked, physical_io from master..sysprocesses PR go