| |
Home |
Return to Collection List
Enable Frames
| Reference Manual |
| About This Book |
![[+]](/dwicons/i_expand.gif)
| Chapter 1 System and User-Defined Datatypes |
|
| Chapter 2 Transact-SQL Functions |
|
| Chapter 3 Global Variables |
|
| Chapter 4 Expressions, Identifiers, and Wildcard Characters |
|
| Chapter 5 Reserved Words |
|
| Chapter 6 SQLSTATE Codes and Messages |
|
| Chapter 7 Commands |
![[-]](/dwicons/i_colpse.gif)
| Chapter 8 System Procedures |
| Introduction to system procedures |
| Permissions on system procedures |
| Executing system procedures |
| Entering parameter values |
| Messages |
| System procedure tables |
| List of system procedures |
|
| sp_activeroles |
|
| sp_addalias |
|
| sp_addauditrecord |
|
| sp_addaudittable |
|
| sp_addengine |
|
| sp_addexeclass |
|
| sp_addextendedproc |
|
| sp_addexternlogin |
|
| sp_addgroup |
|
| sp_addlanguage |
|
| sp_addlogin |
|
| sp_addmessage |
|
| sp_addobjectdef |
|
| sp_add_qpgroup |
|
| sp_addremotelogin |
|
| sp_add_resource_limit |
|
| sp_addsegment |
|
| sp_addserver |
|
| sp_addthreshold |
|
| sp_add_time_range |
|
| sp_addtype |
|
| sp_addumpdevice |
|
| sp_adduser |
|
| sp_altermessage |
|
| sp_audit |
|
| sp_autoconnect |
|
| sp_bindcache |
|
| 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_commonkey |
|
| sp_companion |
|
| sp_configure |
|
| sp_copy_all_qplans |
|
| sp_copy_qplan |
|
| sp_countmetadata |
|
| sp_cursorinfo |
|
| sp_dboption |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
|
| Permissions |
| See also |
|
| sp_dbrecovery_order |
|
| sp_dbremap |
|
| sp_defaultloc |
|
| sp_depends |
|
| sp_deviceattr |
|
| sp_diskdefault |
|
| sp_displayaudit |
|
| sp_displaylevel |
|
| sp_displaylogin |
|
| sp_displayroles |
|
| sp_dropalias |
|
| sp_drop_all_qplans |
|
| sp_dropdevice |
|
| sp_dropengine |
|
| sp_dropexeclass |
|
| sp_dropextendedproc |
|
| sp_dropexternlogin |
|
| sp_dropglockpromote |
|
| sp_dropgroup |
|
| sp_dropkey |
|
| sp_droplanguage |
|
| sp_droplogin |
|
| sp_dropmessage |
|
| sp_dropobjectdef |
|
| sp_drop_qpgroup |
|
| sp_drop_qplan |
|
| sp_dropremotelogin |
|
| sp_drop_resource_limit |
|
| sp_droprowlockpromote |
|
| sp_dropsegment |
|
| sp_dropserver |
|
| sp_dropthreshold |
|
| sp_drop_time_range |
|
| 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_flushstats |
|
| sp_forceonline_db |
|
| sp_forceonline_object |
|
| sp_forceonline_page |
|
| sp_foreignkey |
|
| sp_freedll |
|
| sp_getmessage |
|
| sp_grantlogin |
|
| sp_ha_admin |
|
| sp_help |
|
| 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_help_qpgroup |
|
| sp_help_qplan |
|
| sp_helpremotelogin |
|
| sp_help_resource_limit |
|
| sp_helprotect |
|
| sp_helpsegment |
|
| sp_helpserver |
|
| sp_helpsort |
|
| sp_helptext |
|
| sp_helpthreshold |
|
| sp_helpuser |
|
| sp_hidetext |
|
| sp_import_qpgroup |
|
| sp_indsuspect |
|
| sp_listsuspect_db |
|
| sp_listsuspect_object |
|
| sp_listsuspect_page |
|
| sp_lock |
|
| sp_locklogin |
|
| sp_logdevice |
|
| sp_loginconfig |
|
| sp_logininfo |
|
| sp_logiosize |
|
| sp_modifylogin |
|
| sp_modify_resource_limit |
|
| sp_modify_time_range |
|
| sp_modifystats |
|
| sp_modifythreshold |
|
| sp_monitor |
|
| sp_monitorconfig |
|
| sp_object_stats |
|
| sp_passthru |
|
| sp_password |
|
| sp_placeobject |
|
| sp_plan_dbccdb |
|
| sp_poolconfig |
|
| sp_primarykey |
|
| sp_processmail |
|
| sp_procqmode |
|
| sp_procxmode |
|
| sp_recompile |
|
| sp_remap |
|
| sp_remoteoption |
|
| sp_remotesql |
|
| sp_rename |
|
| sp_renamedb |
|
| sp_rename_qpgroup |
|
| sp_reportstats |
|
| sp_revokelogin |
|
| sp_role |
|
| sp_sendmsg |
|
| sp_serveroption |
|
| sp_setlangalias |
|
| sp_setpglockpromote |
|
| sp_setpsexe |
|
| sp_set_qplan |
|
| sp_setrowlockpromote |
|
| sp_setsuspect_granularity |
|
| sp_setsuspect_threshold |
|
| sp_showcontrolinfo |
|
| sp_showexeclass |
|
| sp_showplan |
|
| sp_showpsexe |
|
| sp_spaceused |
|
| sp_ssladmin |
|
| sp_syntax |
|
| sp_sysmon |
|
| sp_thresholdaction |
|
| sp_transactions |
|
| sp_unbindcache |
|
| sp_unbindcache_all |
|
| sp_unbindefault |
|
| sp_unbindexeclass |
|
| sp_unbindmsg |
|
| sp_unbindrule |
|
| sp_volchanged |
|
| sp_who |
|
| Chapter 9 Catalog Stored Procedures |
|
| Chapter 10 System Extended Stored Procedures |
|
| Chapter 11 dbcc Stored Procedures |
|
| Chapter 12 System Tables |
|
| Chapter 13 dbccdb Tables |