系统存储过程Active Directory 过程sp_ActiveDirectory_Obj sp_ActiveDirectory_SCP 目录过程sp_column_privileges sp_special_columnssp_columns sp_sproc_columnssp_databases sp_statisticssp_fkeys sp_stored_proceduressp_pkeys sp_table_privilegessp_server_info sp_tables 游标过程sp_cursor_list sp_describe_cursor_columnssp_describe_cursor sp_describe_cursor_tables 数据库维护计划过程sp_add_maintenance_plan sp_delete_maintenance_plan_dbsp_add_maintenance_plan_db sp_delete_maintenance_plan_jobsp_add_maintenance_plan_job sp_help_maintenance_plansp_delete_maintenance_plan 分布式查询过程sp_addlinkedserver sp_indexessp_addlinkedsrvlogin sp_linkedserverssp_catalogs sp_primarykeyssp_column_privileges_ex sp_serveroptionsp_columns_ex sp_table_privileges_exsp_droplinkedsrvlogin sp_tables_exsp_foreignkeys 全文检索过程sp_fulltext_catalog sp_help_fulltext_catalogs_cursorsp_fulltext_column sp_help_fulltext_columnssp_fulltext_database sp_help_fulltext_columns_cursorsp_fulltext_service sp_help_fulltext_tablessp_fulltext_table sp_help_fulltext_tables_cursorsp_help_fulltext_catalogs 日志传送过程sp_add_log_shipping_database sp_delete_log_shipping_databasesp_add_log_shipping_plan sp_delete_log_shipping_plansp_add_log_shipping_plan_database sp_delete_log_shipping_plan_databasesp_add_log_shipping_primary sp_delete_log_shipping_primarysp_add_log_shipping_secondary sp_delete_log_shipping_secondarysp_can_tlog_be_applied sp_get_log_shipping_monitor_infosp_change_monitor_role sp_remove_log_shipping_monitorsp_change_primary_role sp_resolve_loginssp_change_secondary_role sp_update_log_shipping_monitor_infosp_create_log_shipping_monitor_account sp_update_log_shipping_plansp_define_log_shipping_monitor sp_update_log_shipping_plan_database OLE 自动化扩展存储过程sp_OACreate sp_OAMethodsp_OADestroy sp_OASetPropertysp_OAGetErrorInfo sp_OAStopsp_OAGetProperty Object Hierarchy Syntax 复制过程sp_add_agent_parameter sp_enableagentoffloadsp_add_agent_profile sp_enumcustomresolverssp_addarticle sp_enumdsnsp_adddistpublisher sp_enumfullsubscriberssp_adddistributiondb sp_expired_subscription_cleanupsp_adddistributor sp_generatefilterssp_addmergealternatepublisher sp_getagentoffloadinfosp_addmergearticle sp_getmergedeletetypesp_addmergefilter sp_get_distributorsp_addmergepublication sp_getqueuedrowssp_addmergepullsubscription sp_getsubscriptiondtspackagenamesp_addmergepullsubscription_agent sp_grant_publication_accesssp_addmergesubscription sp_help_agent_defaultsp_addpublication sp_help_agent_parametersp_addpublication_snapshot sp_help_agent_profilesp_addpublisher70 sp_helparticlesp_addpullsubscription sp_helparticlecolumnssp_addpullsubscription_agent sp_helparticledtssp_addscriptexec sp_helpdistpublishersp_addsubscriber sp_helpdistributiondbsp_addsubscriber_schedule sp_helpdistributorsp_addsubscription sp_helpmergealternatepublishersp_addsynctriggers sp_helpmergearticlesp_addtabletocontents sp_helpmergearticlecolumnsp_adjustpublisheridentityrange sp_helpmergearticleconflictssp_article_validation sp_helpmergeconflictrowssp_articlecolumn sp_helpmergedeleteconflictrowssp_articlefilter sp_helpmergefiltersp_articlesynctranprocs sp_helpmergepublicationsp_articleview sp_helpmergepullsubscriptionsp_attachsubscription sp_helpmergesubscriptionsp_browsesnapshotfolder sp_helppublicationsp_browsemergesnapshotfolder sp_help_publication_accesssp_browsereplcmds sp_helppullsubscriptionsp_change_agent_parameter sp_helpreplfailovermodesp_change_agent_profile sp_helpreplicationdboptionsp_changearticle sp_helpreplicationoptionsp_changedistpublisher sp_helpsubscriberinfosp_changedistributiondb sp_helpsubscriptionsp_changedistributor_password sp_ivindexhasnullcolssp_changedistributor_property sp_helpsubscription_propertiessp_changemergearticle sp_link_publicationsp_changemergefilter sp_marksubscriptionvalidationsp_changemergepublication sp_mergearticlecolumnsp_changemergepullsubscription sp_mergecleanupmetadatasp_changemergesubscription sp_mergedummyupdatesp_changepublication sp_mergesubscription_cleanupsp_changesubscriber sp_publication_validationsp_changesubscriber_schedule sp_refreshsubscriptionssp_changesubscriptiondtsinfo sp_reinitmergepullsubscriptionsp_changesubstatus sp_reinitmergesubscriptionsp_change_subscription_properties sp_reinitpullsubscriptionsp_check_for_sync_trigger sp_reinitsubscriptionsp_copymergesnapshot sp_removedbreplicationsp_copysnapshot sp_repladdcolumnsp_copysubscription sp_replcmdssp_deletemergeconflictrow sp_replcounterssp_disableagentoffload sp_repldonesp_drop_agent_parameter sp_repldropcolumnsp_drop_agent_profile sp_replflushsp_droparticle sp_replicationdboptionsp_dropanonymouseagent sp_replication_agent_checkupsp_dropdistpublisher sp_replqueuemonitorsp_dropdistributiondb sp_replsetoriginatorsp_dropmergealternatepublisher sp_replshowcmdssp_dropdistributor sp_repltranssp_dropmergearticle sp_restoredbreplicationsp_dropmergefilter sp_revoke_publication_access sp_scriptsubconflicttablesp_dropmergepublication sp_script_synctran_commandssp_dropmergepullsubscription sp_setreplfailovermode sp_showrowreplicainfosp_dropmergesubscription sp_subscription_cleanupsp_droppublication sp_table_validationsp_droppullsubscription sp_update_agent_profilesp_dropsubscriber sp_validatemergepublicationsp_dropsubscription sp_validatemergesubscriptionsp_dsninfo sp_vupgrade_replicationsp_dumpparamcmd 安全过程sp_addalias sp_droprolemembersp_addapprole sp_dropserversp_addgroup sp_dropsrvrolemembersp_addlinkedsrvlogin sp_dropusersp_addlogin sp_grantdbaccesssp_addremotelogin sp_grantloginsp_addrole sp_helpdbfixedrolesp_addrolemember sp_helpgroupsp_addserver sp_helplinkedsrvloginsp_addsrvrolemember sp_helploginssp_adduser sp_helpntgroupsp_approlepassword sp_helpremoteloginsp_changedbowner sp_helprolesp_changegroup sp_helprolemembersp_changeobjectowner sp_helprotectsp_change_users_login sp_helpsrvrolesp_dbfixedrolepermission sp_helpsrvrolemembersp_defaultdb sp_helpusersp_defaultlanguage sp_MShasdbaccesssp_denylogin sp_passwordsp_dropalias sp_remoteoptionsp_dropapprole sp_revokedbaccesssp_dropgroup sp_revokeloginsp_droplinkedsrvlogin sp_setapprolesp_droplogin sp_srvrolepermissionsp_dropremotelogin sp_validateloginssp_droprole SQL 邮件过程sp_processmail xp_sendmailxp_deletemail xp_startmailxp_findnextmsg xp_stopmailxp_readmail SQL 事件探查器过程sp_trace_create sp_trace_setfiltersp_trace_generateevent sp_trace_setstatussp_trace_setevent SQL Server 代理程序过程sp_add_alert sp_help_jobhistorysp_add_category sp_help_jobschedulesp_add_job sp_help_jobserversp_add_jobschedule sp_help_jobstepsp_add_jobserver sp_help_notificationsp_add_jobstep sp_help_operatorsp_add_notification sp_help_targetserversp_add_operator sp_help_targetservergroupsp_add_targetservergroup sp_helptasksp_add_targetsvrgrp_member sp_manage_jobs_by_loginsp_addtask sp_msx_defectsp_apply_job_to_targets sp_msx_enlistsp_delete_alert sp_post_msx_operationsp_delete_category sp_purgehistorysp_delete_job sp_purge_jobhistorysp_delete_jobschedule sp_reassigntasksp_delete_jobserver sp_remove_job_from_targetssp_delete_jobstep sp_resync_targetserversp_delete_notification sp_start_jobsp_delete_operator sp_stop_jobsp_delete_targetserver sp_update_alertsp_delete_targetservergroup sp_update_categorysp_delete_targetsvrgrp_member sp_update_jobsp_droptask sp_update_jobschedulesp_help_alert sp_update_jobstepsp_help_category sp_update_notificationsp_help_downloadlist sp_update_operatorsp_helphistory sp_update_targetservergroupsp_help_job sp_updatetask xp_sqlagent_proxy_account 系统过程sp_add_data_file_recover_suspect_db sp_helpconstraintsp_addextendedproc sp_helpdbsp_addextendedproperty sp_helpdevicesp_add_log_file_recover_suspect_db sp_helpextendedprocsp_addmessage sp_helpfilesp_addtype sp_helpfilegroupsp_addumpdevice sp_helpindexsp_altermessage sp_helplanguagesp_autostats sp_helpserversp_attach_db sp_helpsortsp_attach_single_file_db sp_helpstatssp_bindefault sp_helptextsp_bindrule sp_helptriggersp_bindsession sp_indexoptionsp_certify_removable sp_invalidate_textptrsp_configure sp_locksp_create_removable sp_monitorsp_createstats sp_procoptionsp_cycle_errorlog sp_recompilesp_datatype_info sp_refreshviewsp_dbcmptlevel sp_releaseapplocksp_dboption sp_renamesp_dbremove sp_renamedbsp_delete_backuphistory sp_resetstatussp_depends sp_serveroptionsp_detach_db sp_setnetnamesp_dropdevice sp_settriggerordersp_dropextendedproc sp_spaceusedsp_dropextendedproperty sp_tableoptionsp_dropmessage sp_unbindefaultsp_droptype sp_unbindrulesp_executesql sp_updateextendedpropertysp_getapplock sp_updatestatssp_getbindtoken sp_validnamesp_help sp_who Web 助手过程sp_dropwebtask sp_makewebtasksp_enumcodepages sp_runwebtask XML 过程sp_xml_preparedocument sp_xml_removedocument 常规扩展过程xp_cmdshell xp_logininfoxp_enumgroups xp_msverxp_findnextmsg xp_revokeloginxp_grantlogin xp_sprintfxp_logevent xp_sqlmaintxp_loginconfig API 系统存储过程用户在 ADO、OLE DB、ODBC 和 DB-Library 应用程序上运行 SQL Server 事件探查器时，可能会注意到系统存储过程的使用不涉及 Transact-SQL 引用。这些存储过程由用于 SQL Server 的 Microsoft OLE DB 提供程序、SQL Server ODBC 驱动程序和 DB-Library 动态链接库 (DLL) 用来执行数据库 API 功能。这些过程只不过是提供程序或驱动程序所使用的机制，用来传达用户对 SQL Server 的请求。它们仅供用于 SQL Server 的 OLE DB 提供程序、SQL Server ODBC 驱动程序和 DB-Library DLL 在内部使用。不支持从 SQL Server 应用程序显式调用它们。 这些存储过程通过所支持的 API 函数，使得它们的全部功能均可由 SQL Sever 应用程序使用。例如，sp_cursor 系统存储过程的游标功能通过 OLE DB API 游标属性和方法可由 OLE DB 应用程序使用，通过 ODBE 游标特性和函数可由 ODBE 应用程序使用，通过 DB-library 游标库可由 DB-Library 应用程序使用。 这些系统存储过程支持 ADO、OLE DB、ODBC 和 DB-Library 游标库的游标功能： sp_cursor sp_cursorclose sp_cursorexecutesp_cursorfetch sp_cursoropen sp_cursoroptionsp_cursorprepare sp_cursorunprepare 这些系统存储过程支持 ADO、OLE DB 和 ODBC 中用于执行 Transact-SQL 语句的比较/执行模型： sp_execute sp_prepare sp_unprepare sp_createorphan 和 sp_droporphans 存储过程用于 ODBC ntext、text 和 image 的处理。 sp_reset_connection 存储过程由 SQL Server 用来支持事务中的远程存储过程调用。 sp_sdidebug 存储过程由 SQL Server 用来调试 Transact-SQL 语句。
上一篇：MySQL基础之函数和存储过程