SQL Server system SPs

SQL Server system SPs

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

0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share