| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Reference Manual Volumes 1 - 4 (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 8 System Procedures |
Chapter 8
This chapter describes the system procedures, which are Sybase-supplied stored procedures used for updating and getting reports from system tables. "List of system procedures" lists the system procedures described in this volume.
Topics covered are:
| Introduction to system procedures |
| Permissions on system procedures |
| Executing system procedures |
| Entering parameter values |
| Messages |
| System procedure tables |
| List of system procedures |
|
| sp_activeroles |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addalias |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addauditrecord |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addaudittable |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addengine |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addexeclass |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addextendedproc |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addexternlogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addlanguage |
| Description |
| Syntax |
| Parameters |
| Examples |
![[+]](/dwicons/i_expand.gif)
| Usage |
| Permissions |
| See also |
|
| sp_addlogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addmessage |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addobjectdef |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_add_qpgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addremotelogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_add_resource_limit |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addsegment |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addserver |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addthreshold |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_add_time_range |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_addtype |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_addumpdevice |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_adduser |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_altermessage |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_audit |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_autoconnect |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_bindcache |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_bindefault |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_bindexeclass |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_bindmsg |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_bindrule |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_cacheconfig |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_cachestrategy |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_changedbowner |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_changegroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_checknames |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_checkreswords |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_checksource |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_chgattribute |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_clearpsexe |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_clearstats |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_client_addr |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_cmp_all_qplans |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_cmp_qplans |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_commonkey |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_companion |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_configure |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_copy_all_qplans |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_copy_qplan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_countmetadata |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_cursorinfo |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dboption |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_dbrecovery_order |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_dbremap |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_defaultloc |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_depends |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_deviceattr |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_diskdefault |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_displayaudit |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_displaylevel |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_displaylogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_displayroles |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropalias |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_drop_all_qplans |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropdevice |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropengine |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropexeclass |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropextendedproc |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropexternlogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropglockpromote |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropkey |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_droplanguage |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_droplogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropmessage |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropobjectdef |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_drop_qpgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_drop_qplan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropremotelogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_drop_resource_limit |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_droprowlockpromote |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropsegment |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropserver |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropthreshold |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_drop_time_range |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_droptype |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dropuser |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_dumpoptimize |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_engine |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_estspace |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_export_qpgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_extendsegment |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_extengine |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_familylock |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_find_qplan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_fixindex |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_flushstats |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_forceonline_db |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_forceonline_object |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_forceonline_page |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_foreignkey |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_freedll |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_getmessage |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_grantlogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_ha_admin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_help |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpartition |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_helpcache |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpconfig |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_helpconstraint |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpdb |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpdevice |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpextendedproc |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpexternlogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpindex |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpjava |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpjoins |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpkey |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helplanguage |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helplog |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpobjectdef |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_help_qpgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_help_qplan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpremotelogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_help_resource_limit |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helprotect |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpsegment |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpserver |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpsort |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_helptext |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpthreshold |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_helpuser |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_hidetext |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_import_qpgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_indsuspect |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_listsuspect_db |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_listsuspect_object |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_listsuspect_page |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_lock |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_locklogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_logdevice |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_loginconfig |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_logininfo |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_logiosize |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_modifylogin |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_modify_resource_limit |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_modify_time_range |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_modifystats |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| Tables used |
| See also |
|
| sp_modifythreshold |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_monitor |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_monitorconfig |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_object_stats |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_passthru |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_password |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_placeobject |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_plan_dbccdb |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_poolconfig |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_primarykey |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_processmail |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_procqmode |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_procxmode |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_recompile |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_remap |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_remoteoption |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_remotesql |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_rename |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_renamedb |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_rename_qpgroup |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_reportstats |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_revokelogin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_role |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_sendmsg |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_serveroption |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_setlangalias |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_setpglockpromote |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_setpsexe |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_set_qplan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_setrowlockpromote |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_setsuspect_granularity |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_setsuspect_threshold |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_showcontrolinfo |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_showexeclass |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_showplan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_showpsexe |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_spaceused |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_ssladmin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_syntax |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| Tables used |
| See also |
|
| sp_sysmon |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
|
| sp_thresholdaction |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| See also |
|
| sp_transactions |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Permissions |
| See also |
|
| sp_unbindcache |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_unbindcache_all |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_unbindefault |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_unbindexeclass |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_unbindmsg |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_unbindrule |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_volchanged |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| sp_who |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
|