System Stored Procedures
sp_databases: List down all the available databases with its size in KB and Remarks if any.
sp_spaceused: Shows following information related to a database table
If executed with Table Name
Available Data Rows in the table
Reserved Disk Space for table
Available Data Size in table
Index_Size on table
and Unused Space.
If executed without any value.
Database Size in MB.
Unallocated Space in MB.
Reserved Space for Database in KB
Data Size in KB
index_size in KB
unused space size in KB
sp_rename:
sp_helptext:
sp_help:
sp_who2:
sp_add_data_file_recover_suspect_db
sp_execute
sp_add_log_file_recover_suspect_db
sp_executesql
sp_addextendedproc
sp_getapplock
sp_addextendedproperty
sp_getbindtoken
sp_addmessage
sp_help
sp_addtype
sp_helpconstraint
sp_addumpdevice
sp_helpdb
sp_altermessage
sp_helpdevice
sp_attach_db
sp_helpextendedproc
sp_attach_single_file_db
sp_helpfile
sp_autostats
sp_helpfilegroup
sp_bindefault
sp_helpindex
sp_bindrule
sp_helplanguage
sp_bindsession
sp_helpserver
sp_certify_removable
sp_helpsort
sp_clean_db_file_free_space
sp_helpstats
sp_clean_db_free_space
sp_helptext
sp_configure
sp_helptrigger
sp_control_plan_guide
sp_indexoption
sp_create_plan_guide
sp_invalidate_textptr
sp_create_plan_guide_from_handle
sp_lock
sp_create_removable
sp_monitor
sp_createstats
sp_prepare
sp_cycle_errorlog
sp_prepexec
sp_datatype_info
sp_prepexecrpc
sp_db_increased_partitions
sp_procoption
sp_dbcmptlevel
sp_recompile
sp_dbmmonitoraddmonitoring
sp_refreshview
sp_dbmmonitorchangealert
sp_releaseapplock
sp_dbmmonitorchangemonitoring
sp_rename
sp_dbmmonitordropalert
sp_renamedb
sp_dbmmonitordropmonitoring
sp_resetstatus
sp_dbmmonitorhelpalert
sp_sequence_get_range (Transact-SQL)
sp_dbmmonitorhelpmonitoring
sp_serveroption
sp_dbmmonitorresults
sp_setnetname
sp_delete_backuphistory
sp_settriggerorder
sp_depends
sp_spaceused
sp_describe_first_result_set (Transact-SQL)
sp_tableoption
sp_describe_undeclared_parameters (Transact-SQL)
sp_unbindefault
sp_detach_db
sp_unbindrule
sp_dropdevice
sp_updateextendedproperty
sp_dropextendedproc
sp_updatestats
sp_dropextendedproperty
sp_unprepare
sp_dropmessage
sp_validname
sp_droptype
sp_who
sp_droptype
sp_who
sp_droptype
sp_who