Note: if the filename has "_no" appended to it, it means that I've found this proc useful, but its not one that I normally install when i go from site to site.

• sp__auditreport.sql_no Runs a report of the audit info and truncates your tables for you.
• sp_block.sql: better view than sp_lock
• sp_blocker.sql: shows info about jobs that are blocking others
• sp_checklog.sql_no: Quick check of the log of the current database
• sp_convert.sql_no: Converts (for the mathematically challenged) from pages to bytes to blocks and all around
• sp_describe.sql: Very nice sp_help replacement
• sp_devspace.sql: Neatly calculates space allocation by device
• sp_devspace1.sql_no: same as above
• sp_devspace2.sql_no: same as above
• sp_findmaxvdevno.sql_no: quick one-statement sql to find the highest unused Device number for admins adding disks
• sp_freeall.sql: Nice summary of all free space in all database devices
• sp_genddl.sql: Nicely creates table ddl.
• sp_getddl.sql_no: same as above
• sp_helpcode.sql: Replacement for sp_helptext, which screws up line wraps when outputtting code
• sp_interfaces.mail: Interesting system for generating interfaces file entries w/o using sybinit; untried
• sp_io.sql: Enhanced sp_who
• sp_ioa.sql: Enhanced sp_who
• sp_opentran.sql: Info about open transactions
• sp_profile_pwdate.sql_no: Profiles users by last password change date
• sp_profile_tables.sql_no: Profiles tables by numer of rows
• sp_profile_totcpu.sql_no: Profiles users by total cpu usage
• sp_profile_totio.sql_no: Profiles users by total i/o
• sp_servermap.sql: Great sp that maps out entire Server
• sp_show.sql: Quick sp to show all objects of a particular type in a database
• sp_showfrag.sql: Shows information about fragments space info for a server
• sp_showuser.sql_no: sp_who replacement
• sp_size.sql_no: Calculates of size of stored procedures
• sp_tablespace.sql: calculatesa reserved and used space for all tables in a database
• sp_thresholdaction.audit.sql_no: Thresholdaction for audit table example
• sp_thresholdaction.dev.sql_no: Development threshold action example (truncates only)
• sp_thresholdaction.open_srv.sql_no: thresholdaction example for use with SQLL Backtrack openserver
• sp_thresholdaction.sql_no: Standard thresholdaction; dumps log to a file
• sp_u_create_constraint_ddl.sql_no: reverse engineer constraint statements on a table
• sp_u_create_index_ddl.sql_no: reverse engineers index ddl
• sp_u_rebuild_index_ddl.sql_no: rebuilds indexes
• sp_unix.sql_no: sp_who replacement
• sp_vdev.sql_no: Info about devices and space avial
• sp_what.sql_no: sp_who replacement
• sp_whodo.sql_no: sp_who replacement
• sp_whom.sql: sp_who replacement