Stored Procedures in Sybase

sp_configure – set db parameters

sp_dboption – set db options

sp_displaylogin – Show login details

sp_help object_name – Object definitions

sp_helpdb dbname – db info

sp_helpdevice - device info

sp_helpindex - index per table info

sp_helpprotect userid – Privileges info

sp_helpsegment – Monitor db sizing

sp_helptext stord_proc – Show stored procs code

sp_helpuser userid - User info

sp_spaceused – db sizing

sp_who userid – Users logged in info