|
System Procedures
The term System Procedures in Adaptive Server® describes
Stored Procedures,
which provide information on
databases,
database objects
and
data
within these
objects
System Procedures always have the prefix "sp_".
List of System Procedures
-
sp_activeroles
-
sp_add_qpgroup
-
sp_add_resource_limit
-
sp_add_time_range
-
sp_addalias
-
sp_addauditrecord
-
sp_addaudittable
-
sp_addengine
-
sp_addexeclass
-
sp_addextendedproc
-
sp_addextenrlogin
-
sp_addgroup
-
sp_addlanguage
-
sp_addlogin
-
sp_addmessage
-
sp_addobjectdef
-
sp_addremotelogin
-
sp_addsegment
-
sp_addserver
-
sp_addthreshold
-
sp_addtype
-
sp_addumpdivice
-
sp_adduser
-
sp_altermessage
-
sp_audit
-
sp_autoconnect
-
sp_bindecache
-
sp_bindefault
-
sp_bindexeclass
-
sp_bindmsg
-
sp_bindrule
-
sp_cacheconfig
-
sp_cachestrategy
-
sp_changedbowner
-
sp_changegroup
-
sp_checknames
-
sp_checkreswords
-
sp_checksource
-
sp_chgattribute
-
sp_clearpsexe
-
sp_clearstats
-
sp_client_addr
-
sp_cmp_all_qplans
-
sp_cmp_qplans
-
sp_columns
-
sp_commonkey
-
sp_config_rep_agent
-
sp_configure
-
sp_copy_all_qplans
-
sp_copy_qplan
-
sp_countmetadata
-
sp_cursorinfo
-
sp_databases
-
sp_datatype_info
-
sp_dbcc_aterws
-
sp_dbcc_configreport
-
sp_dbcc_createws
-
sp_dbcc_deletedb
-
sp_dbcc_deletehistory
-
sp_differentialreport
-
sp_dbcc_evaluatedb
-
sp_dbcc_faultreport
-
sp_dbcc_fullreport
-
sp_dbcc_runcheck
-
sp_dbcc_statisticsreport
-
sp_dbcc_summaryreport
-
sp_dbcc_updateconfig
-
sp_dboption
-
sp_dbrecovery_order
-
sp_defaultloc
-
sp_depends
-
sp_deviceattr
-
sp_diskdefault
-
sp_displayaudit
-
sp_displaylevel
-
sp_displaylogin
-
sp_activeroles
-
sp_drop_all_qplans
-
sp_drop_qpgroup
-
sp_drop_qplan
-
sp_drop_recource_limit
-
sp_drop_time_range
-
sp_dropalias
-
sp_dropdevice
-
sp_dropeggine
-
sp_dropexeclass
-
sp_dropextendedproc
-
sp_dropexternlogin
-
sp_dropglockpromote
-
sp_dropgroup
-
sp_dropkey
-
sp_droplanguage
-
sp_droplogin
-
sp_dropmessages
-
sp_dropobjectdef
-
sp_dropremotelogin
-
sp_droprowlockpromote
-
sp_dropsegment
-
sp_dropsever
-
sp_dropthreshold
-
sp_droptype
-
sp_dropuser
-
sp_dumpoptimize
-
sp_engine
-
sp_estspace
-
sp_export_qpgroup
-
sp_extendsegment
-
sp_extengine
-
sp_familylock
-
sp_find_qplan
-
sp_fixindex
-
sp_fkey
-
sp_flushstats
-
sp_forceonline_db
-
sp_forceonline_object
-
sp_forceonline_page
-
sp_foreignkey
-
sp_freedll
-
sp_getmessage
-
sp_help
-
sp_help_qpgroup
-
sp_help_qplan
-
sp_help_rep_agent
-
sp_helpresource_limit
-
sp_helpartition
-
sp_helpcache
-
sp_helpconfig
-
sp_helpconstraint
-
sp_helpdb
-
sp_helpdevice
-
sp_helpextendedproc
-
sp_helpexternlogin
-
sp_helpgroup
-
sp_helpindex
-
sp_helpjava
-
sp_helpjoins
-
sp_helpkey
-
sp_helplanguage
-
sp_helplog
-
sp_helpobjectdef
-
sp_helpremotelogin
-
sp_helprotect
-
sp_helpsegment
-
sp_helpserver
-
sp_helpsort
-
sp_helptext
-
sp_helpthreshold
-
sp_helpuser
-
sp_hidetext
-
sp_import_qpgroup
-
sp_indsuspect
-
sp_indsuspect_db
-
sp_indsuspect_object
-
sp_indsuspect_page
-
sp_lock
-
sp_locklogin
-
sp_logdivice
-
sp_logiosize
-
sp_makesuspect_obj
-
sp_modify_resource_limit
-
sp_modify_time_range
-
sp_modifylogin
-
sp_modifystats
-
sp_modifythreshold
-
sp_monitor
-
sp_monitorconfig
-
sp_object_stats
-
sp_passthru
-
sp_password
-
sp_pkeys
-
sp_placeobject
-
sp_plan_dbcc
-
sp_poolconfig
-
sp_primarykey
-
sp_procqmode
-
sp_procxmode
-
sp_rebuild_text
-
sp_recompile
-
sp_remoteoption
-
sp_remotesql
-
sp_rename
-
sp_rename_qpgroup
-
sp_renamedb
-
sp_reprotstats
-
sp_role
-
sp_server_info
-
sp_serveroption
-
sp_set_qplan
-
sp_setlangalias
-
sp_setpglockpromote
-
sp_setpsexe
-
sp_setrowlockpromote
-
sp_setsuspect_threshold
-
sp_shmdumpconfig
-
sp_shmdumpsize
-
sp_showcontrolinfo
-
sp_showexeclass
-
sp_showplan
-
sp_showpexe
-
sp_spaceused
-
sp_special_columns
-
sp_sproc_columns
-
sp_start_rep_agent
-
sp_statistics
-
sp_stop_rep_agent
-
sp_syntax
-
sp_sysmon
-
sp_table_privileges
-
sp_tables
-
sp_thrsholdaction
-
sp_unbindcache
-
sp_unbindcache_all
-
sp_unbindefault
-
sp_unbindexeclass
-
sp_unbindmsg
-
sp_unbindrule
-
sp_volchanged
-
sp_who
See also:
Command Syntax Convention.
|
