MS-SQL系统存储过程

阿使得肌肤·

系统存储过程
　　在 Microsoft® SQL Server™ 中，许多管理和信息活动可以通过系统存储过程执行。系统存储过程按这些分类分组。
分类描述Active Directory 过程用于在 Microsoft Windows® 2000 Active Directory™ 中注册 SQL Server 实例和 SQL Server 数据库。目录过程执行 ODBC 数据字典功能，并隔离 ODBC 应用程序，使之不受基础系统表更改的影响。游标过程执行游标变量功能。数据库维护计划过程用于设置确保数据库性能所需的核心维护任务。分布式查询过程用于执行和管理分布式查询。全文检索过程用于执行和查询全文索引。日志传送过程用于配置和管理日志传送。OLE 自动化过程允许在标准 Transact-SQL 批处理中使用标准 OLE 自动化对象。复制过程用于管理复制。安全过程用于管理安全性。SQL 邮件过程用于从 SQL Server 内执行电子邮件操作。SQL 事件探查器过程由 SQL 事件探查器用于监视性能和活动。SQL Server 代理程序过程由 SQL Server 代理程序用于管理调度的活动和事件驱动活动。系统过程用于 SQL Server 的常规维护。Web 助手过程由 Web 助手使用。XML 过程用于可扩展标记语言 (XML) 文本管理。常规扩展过程提供从 SQL Server 到外部程序的接口，以便进行各种维护活动。　　
<!--NOTE-->
　　说明  除非特别指明，所有系统存储过程返回 0 值表示成功，返回非零值则表示失败。
<!--/NOTE-->　　
Active Directory 过程sp_ActiveDirectory_Objsp_ActiveDirectory_SCP　　
 
目录过程sp_column_privilegessp_special_columnssp_columnssp_sproc_columnssp_databasessp_statisticssp_fkeyssp_stored_proceduressp_pkeyssp_table_privilegessp_server_infosp_tables　　
游标过程sp_cursor_listsp_describe_cursor_columnssp_describe_cursorsp_describe_cursor_tables　　
数据库维护计划过程sp_add_maintenance_plansp_delete_maintenance_plan_dbsp_add_maintenance_plan_dbsp_delete_maintenance_plan_jobsp_add_maintenance_plan_jobsp_help_maintenance_plansp_delete_maintenance_plan 　　
分布式查询过程sp_addlinkedserversp_indexessp_addlinkedsrvloginsp_linkedserverssp_catalogssp_primarykeyssp_column_privileges_exsp_serveroptionsp_columns_exsp_table_privileges_exsp_droplinkedsrvloginsp_tables_exsp_foreignkeys 　　
全文检索过程sp_fulltext_catalogsp_help_fulltext_catalogs_cursorsp_fulltext_columnsp_help_fulltext_columnssp_fulltext_databasesp_help_fulltext_columns_cursorsp_fulltext_servicesp_help_fulltext_tablessp_fulltext_tablesp_help_fulltext_tables_cursorsp_help_fulltext_catalogs 　　
日志传送过程sp_add_log_shipping_databasesp_delete_log_shipping_databasesp_add_log_shipping_plansp_delete_log_shipping_plansp_add_log_shipping_plan_databasesp_delete_log_shipping_plan_databasesp_add_log_shipping_primarysp_delete_log_shipping_primarysp_add_log_shipping_secondarysp_delete_log_shipping_secondarysp_can_tlog_be_appliedsp_get_log_shipping_monitor_infosp_change_monitor_rolesp_remove_log_shipping_monitorsp_change_primary_rolesp_resolve_loginssp_change_secondary_rolesp_update_log_shipping_monitor_infosp_create_log_shipping_monitor_accountsp_update_log_shipping_plansp_define_log_shipping_monitorsp_update_log_shipping_plan_database　　
OLE 自动化扩展存储过程sp_OACreatesp_OAMethodsp_OADestroysp_OASetPropertysp_OAGetErrorInfosp_OAStopsp_OAGetPropertyObject Hierarchy Syntax　　
复制过程sp_add_agent_parametersp_enableagentoffloadsp_add_agent_profilesp_enumcustomresolverssp_addarticlesp_enumdsnsp_adddistpublishersp_enumfullsubscriberssp_adddistributiondbsp_expired_subscription_cleanupsp_adddistributorsp_generatefilterssp_addmergealternatepublishersp_getagentoffloadinfosp_addmergearticlesp_getmergedeletetypesp_addmergefiltersp_get_distributorsp_addmergepublicationsp_getqueuedrowssp_addmergepullsubscriptionsp_getsubscriptiondtspackagenamesp_addmergepullsubscription_agentsp_grant_publication_accesssp_addmergesubscriptionsp_help_agent_defaultsp_addpublicationsp_help_agent_parametersp_addpublication_snapshotsp_help_agent_profilesp_addpublisher70sp_helparticlesp_addpullsubscriptionsp_helparticlecolumnssp_addpullsubscription_agentsp_helparticledtssp_addscriptexecsp_helpdistpublishersp_addsubscribersp_helpdistributiondbsp_addsubscriber_schedulesp_helpdistributorsp_addsubscriptionsp_helpmergealternatepublishersp_addsynctriggerssp_helpmergearticlesp_addtabletocontentssp_helpmergearticlecolumnsp_adjustpublisheridentityrangesp_helpmergearticleconflictssp_article_validationsp_helpmergeconflictrowssp_articlecolumnsp_helpmergedeleteconflictrowssp_articlefiltersp_helpmergefiltersp_articlesynctranprocssp_helpmergepublicationsp_articleviewsp_helpmergepullsubscriptionsp_attachsubscriptionsp_helpmergesubscriptionsp_browsesnapshotfoldersp_helppublicationsp_browsemergesnapshotfoldersp_help_publication_accesssp_browsereplcmdssp_helppullsubscriptionsp_change_agent_parametersp_helpreplfailovermodesp_change_agent_profilesp_helpreplicationdboptionsp_changearticlesp_helpreplicationoptionsp_changedistpublishersp_helpsubscriberinfosp_changedistributiondbsp_helpsubscriptionsp_changedistributor_passwordsp_ivindexhasnullcolssp_changedistributor_propertysp_helpsubscription_propertiessp_changemergearticlesp_link_publicationsp_changemergefiltersp_marksubscriptionvalidationsp_changemergepublicationsp_mergearticlecolumnsp_changemergepullsubscriptionsp_mergecleanupmetadatasp_changemergesubscriptionsp_mergedummyupdatesp_changepublicationsp_mergesubscription_cleanupsp_changesubscribersp_publication_validationsp_changesubscriber_schedulesp_refreshsubscriptionssp_changesubscriptiondtsinfosp_reinitmergepullsubscriptionsp_changesubstatussp_reinitmergesubscriptionsp_change_subscription_propertiessp_reinitpullsubscriptionsp_check_for_sync_triggersp_reinitsubscriptionsp_copymergesnapshotsp_removedbreplicationsp_copysnapshotsp_repladdcolumnsp_copysubscriptionsp_replcmdssp_deletemergeconflictrowsp_replcounterssp_disableagentoffloadsp_repldonesp_drop_agent_parametersp_repldropcolumnsp_drop_agent_profilesp_replflushsp_droparticlesp_replicationdboptionsp_dropanonymouseagentsp_replication_agent_checkupsp_dropdistpublishersp_replqueuemonitorsp_dropdistributiondbsp_replsetoriginatorsp_dropmergealternatepublishersp_replshowcmdssp_dropdistributorsp_repltranssp_dropmergearticlesp_restoredbreplicationsp_dropmergefiltersp_revoke_publication_access sp_scriptsubconflicttablesp_dropmergepublicationsp_script_synctran_commandssp_dropmergepullsubscriptionsp_setreplfailovermode sp_showrowreplicainfosp_dropmergesubscriptionsp_subscription_cleanupsp_droppublicationsp_table_validationsp_droppullsubscriptionsp_update_agent_profilesp_dropsubscribersp_validatemergepublicationsp_dropsubscriptionsp_validatemergesubscriptionsp_dsninfosp_vupgrade_replicationsp_dumpparamcmd 　　
安全过程sp_addaliassp_droprolemembersp_addapprolesp_dropserversp_addgroupsp_dropsrvrolemembersp_addlinkedsrvloginsp_dropusersp_addloginsp_grantdbaccesssp_addremoteloginsp_grantloginsp_addrolesp_helpdbfixedrolesp_addrolemembersp_helpgroupsp_addserversp_helplinkedsrvloginsp_addsrvrolemembersp_helploginssp_addusersp_helpntgroupsp_approlepasswordsp_helpremoteloginsp_changedbownersp_helprolesp_changegroupsp_helprolemembersp_changeobjectownersp_helprotectsp_change_users_loginsp_helpsrvrolesp_dbfixedrolepermissionsp_helpsrvrolemembersp_defaultdbsp_helpusersp_defaultlanguagesp_MShasdbaccesssp_denyloginsp_passwordsp_dropaliassp_remoteoptionsp_dropapprolesp_revokedbaccesssp_dropgroupsp_revokeloginsp_droplinkedsrvloginsp_setapprolesp_droploginsp_srvrolepermissionsp_dropremoteloginsp_validateloginssp_droprole 　　
SQL 邮件过程sp_processmailxp_sendmailxp_deletemailxp_startmailxp_findnextmsgxp_stopmailxp_readmail 　　
SQL 事件探查器过程sp_trace_createsp_trace_setfiltersp_trace_generateeventsp_trace_setstatussp_trace_setevent 　　
SQL Server 代理程序过程sp_add_alertsp_help_jobhistorysp_add_categorysp_help_jobschedulesp_add_jobsp_help_jobserversp_add_jobschedulesp_help_jobstepsp_add_jobserversp_help_notificationsp_add_jobstepsp_help_operatorsp_add_notificationsp_help_targetserversp_add_operatorsp_help_targetservergroupsp_add_targetservergroupsp_helptasksp_add_targetsvrgrp_membersp_manage_jobs_by_loginsp_addtasksp_msx_defectsp_apply_job_to_targetssp_msx_enlistsp_delete_alertsp_post_msx_operationsp_delete_categorysp_purgehistorysp_delete_jobsp_purge_jobhistorysp_delete_jobschedulesp_reassigntasksp_delete_jobserversp_remove_job_from_targetssp_delete_jobstepsp_resync_targetserversp_delete_notificationsp_start_jobsp_delete_operatorsp_stop_jobsp_delete_targetserversp_update_alertsp_delete_targetservergroupsp_update_categorysp_delete_targetsvrgrp_membersp_update_jobsp_droptasksp_update_jobschedulesp_help_alertsp_update_jobstepsp_help_categorysp_update_notificationsp_help_downloadlistsp_update_operatorsp_helphistorysp_update_targetservergroupsp_help_jobsp_updatetask xp_sqlagent_proxy_account　　
系统过程sp_add_data_file_recover_suspect_dbsp_helpconstraintsp_addextendedprocsp_helpdbsp_addextendedpropertysp_helpdevicesp_add_log_file_recover_suspect_dbsp_helpextendedprocsp_addmessagesp_helpfilesp_addtypesp_helpfilegroupsp_addumpdevicesp_helpindexsp_altermessagesp_helplanguagesp_autostatssp_helpserversp_attach_dbsp_helpsortsp_attach_single_file_dbsp_helpstatssp_bindefaultsp_helptextsp_bindrulesp_helptriggersp_bindsessionsp_indexoptionsp_certify_removablesp_invalidate_textptrsp_configuresp_locksp_create_removablesp_monitorsp_createstatssp_procoptionsp_cycle_errorlogsp_recompilesp_datatype_infosp_refreshviewsp_dbcmptlevelsp_releaseapplocksp_dboptionsp_renamesp_dbremovesp_renamedbsp_delete_backuphistorysp_resetstatussp_dependssp_serveroptionsp_detach_dbsp_setnetnamesp_dropdevicesp_settriggerordersp_dropextendedprocsp_spaceusedsp_dropextendedpropertysp_tableoptionsp_dropmessagesp_unbindefaultsp_droptypesp_unbindrulesp_executesqlsp_updateextendedpropertysp_getapplocksp_updatestatssp_getbindtokensp_validnamesp_helpsp_who　　
Web 助手过程sp_dropwebtasksp_makewebtasksp_enumcodepagessp_runwebtask　　
XML 过程sp_xml_preparedocumentsp_xml_removedocument　　
[table=560][tr]常规扩展过程[/tr][tr][td=1,1,47%]xp_cmdshell[/td][td=1,1,53%]xp_logininfo[/td][/tr][tr][td=1,1,47%]xp_enumgroups[/td][td=1,1,53%]xp_msver[/td][/tr][tr][td=1,1,47%]xp_findnextmsg[/td][td=1,1,53%]xp_revokelogin[/td][/tr][tr][td=1,1,47%]xp_grantlogin[/td][td=1,1,53%]xp_sprintf[/td][/tr][tr][td=1,1,47%]http://huanghuaibin.iyunv.com/admin/blogs/t