Object Hierarchy Syntax
sp_ActiveDirectory_Obj
sp_add_agent_parameter
sp_add_agent_profile
sp_add_alert
sp_add_category
sp_add_data_file_recover_suspect_db
sp_add_job
sp_add_jobschedule
sp_add_jobserver
sp_add_jobstep
sp_add_log_file_recover_suspect_db
sp_add_log_shipping_database
sp_add_log_shipping_plan
sp_add_log_shipping_plan_database
sp_add_log_shipping_primary
sp_add_log_shipping_secondary
sp_add_maintenance_plan
sp_add_maintenance_plan_db
sp_add_maintenance_plan_job
sp_add_notification
sp_add_operator
sp_add_targetservergroup
sp_add_targetsvrgrp_member
sp_addalias
sp_addapprole
sp_addarticle
sp_adddistpublisher
sp_adddistributiondb
sp_adddistributor
sp_addextendedproc
sp_addextendedproperty
sp_addgroup
sp_addlinkedserver
sp_addlinkedsrvlogin
sp_addlinkedsrvlogin
sp_addlogin
sp_addmergealternatepublisher
sp_addmergearticle
sp_addmergefilter
sp_addmergepublication
sp_addmergepullsubscription
sp_addmergepullsubscription_agent
sp_addmergesubscription
sp_addmessage
sp_addpublication
sp_addpublication_snapshot
sp_addpublisher70
sp_addpullsubscription
sp_addpullsubscription_agent
sp_addremotelogin
sp_addrole
sp_addrolemember
sp_addscriptexec
sp_addserver
sp_addsrvrolemember
sp_addsubscriber
sp_addsubscriber_schedule
sp_addsubscription
sp_addsynctriggers
sp_addtabletocontents
sp_addtask
sp_addtype
sp_addumpdevice
sp_adduser
sp_adjustpublisheridentityrange
sp_altermessage
sp_apply_job_to_targets
sp_approlepassword
sp_article_validation
sp_articlecolumn
sp_articlefilter
sp_articlesynctranprocs
sp_articleview
sp_attach_db
sp_attach_single_file_db
sp_attachsubscription
sp_autostats
sp_bindefault
sp_bindrule
sp_bindsession
sp_browsemergesnapshotfolder
sp_browsereplcmds
sp_browsesnapshotfolder
sp_can_tlog_be_applied
sp_catalogs
sp_certify_removable
sp_change_agent_parameter
sp_change_agent_profile
sp_change_monitor_role
sp_change_primary_role
sp_change_secondary_role
sp_change_subscription_properties
sp_change_users_login
sp_changearticle
sp_changedbowner
sp_changedistpublisher
sp_changedistributiondb
sp_changedistributor_password
sp_changedistributor_property
sp_changegroup
sp_changemergearticle
sp_changemergefilter
sp_changemergepublication
sp_changemergepullsubscription
sp_changemergesubscription
sp_changeobjectowner
sp_changepublication
sp_changesubscriber
sp_changesubscriber_schedule
sp_changesubscriptiondtsinfo
sp_changesubstatus
sp_check_for_sync_trigger
sp_column_privileges
sp_column_privileges_ex
sp_columns
sp_columns_ex
sp_configure
sp_copymergesnapshot
sp_copysnapshot
sp_copysubscription
sp_create_log_shipping_monitor_account
sp_create_removable
sp_createorphan
sp_createstats
sp_cursor
sp_cursor_list
sp_cursorexecute
sp_cursorfetch
sp_cursoroption
sp_cursorprepare
sp_cycle_errorlog
sp_databases
sp_datatype_info
sp_dbcmptlevel
sp_dbfixedrolepermission
sp_dboption
sp_dbremove
sp_defaultdb
sp_defaultlanguage
sp_define_log_shipping_monitor
sp_delete_alert
sp_delete_backuphistory
sp_delete_category
sp_delete_job
sp_delete_jobschedule
sp_delete_jobserver
sp_delete_jobstep
sp_delete_maintenance_plan
sp_delete_notification
sp_delete_operator
sp_delete_targetserver
sp_delete_targetservergroup
sp_delete_targetsvrgrp_member
sp_deletemergeconflictrow
sp_denylogin
sp_depends
sp_describe_cursor
sp_describe_cursor_tables
sp_detach_db
sp_disableagentoffload
sp_drop_agent_parameter
sp_drop_agent_profile
sp_dropalias
sp_dropanonymouseagent
sp_dropapprole
sp_droparticle
sp_dropdevice
sp_dropdistpublisher
sp_dropdistributiondb
sp_dropdistributor
sp_dropextendedproc
sp_dropextendedproperty
sp_dropgroup
sp_droplinkedsrvlogin
sp_droplinkedsrvlogin
sp_droplogin
sp_dropmergealternatepublisher
sp_dropmergearticle
sp_dropmergefilter
sp_dropmergepublication
sp_dropmergepullsubscription
sp_dropmergesubscription
sp_dropmessage
sp_droporphans
sp_droppublication
sp_droppullsubscription
sp_dropremotelogin
sp_droprole
sp_dropsubscriber
sp_dropsubscription
sp_droptask
sp_droptype
sp_dropwebtask
sp_dsninfo
sp_dumpparamcmd
sp_enumcodepages
sp_execute
sp_executesql
sp_fkeys
sp_foreignkeys
sp_fulltext_catalog
sp_fulltext_column
sp_fulltext_database
sp_fulltext_service
sp_fulltext_table
sp_getapplock
sp_getbindtoken
sp_help
sp_help_alert
sp_help_category
sp_help_downloadlist
sp_help_fulltext_catalogs
sp_help_fulltext_catalogs_cursor
sp_help_fulltext_columns
sp_help_fulltext_columns_cursor
sp_help_fulltext_tables
sp_help_fulltext_tables_cursor
sp_help_job
sp_helphistory
sp_makewebtask
sp_OACreate
sp_OADestroy
sp_OAGetErrorInfo
sp_OAGetProperty
sp_OAMethod
sp_OASetProperty
sp_OAStop
sp_password
sp_pkeys
sp_post_msx_operation
sp_prepare
sp_processmail
sp_purge_jobhistory
sp_purgehistory
sp_reassigntask
sp_remoteoption
sp_remove_job_from_targets
sp_replcounters
sp_repldone
sp_repldropcolumn
sp_replflush
sp_replication_agent_checkup
sp_replicationdboption
sp_replqueuemonitor
sp_replsetoriginator
sp_replshowcmds
sp_repltrans
sp_reset_connection
sp_resetstatus
sp_restoredbreplication
sp_resync_targetserver
sp_resyncmergesubscription
sp_revoke_publication_access
sp_revokedbaccess
sp_revokelogin
sp_runwebtask
sp_script_synctran_commands
sp_scriptsubconflicttable
sp_sdidebug
sp_server_info
sp_serveroption
sp_setapprole
sp_setnetname
sp_setreplfailovermode
sp_settriggerorder
sp_showrowreplicainfo
sp_spaceused
sp_srvrolepermission
sp_start_job
sp_stop_job
sp_stored_procedures
sp_subscription_cleanup
sp_table_privileges
sp_table_validation
sp_tableoption
sp_tables
sp_tables_ex
sp_trace_create
sp_trace_generateevent
sp_trace_setevent
sp_trace_setfilter
sp_trace_setstatus
sp_unbindefault
sp_unbindrule
sp_unprepare
sp_update_agent_profile
sp_update_alert
sp_update_category
sp_update_job
sp_update_jobschedule
sp_update_jobstep
sp_update_notification
sp_update_operator
sp_update_targetservergroup
sp_updateextendedproperty
sp_updatestats
sp_updatetask
sp_validatelogins
sp_validatemergepublication
sp_validatemergesubscription
sp_validname
sp_vupgrade_replication
sp_who
sp_xml_preparedocument
sp_xml_removedocument
xp_cmdshell
xp_deletemail
xp_enumgroups
xp_findnextmsg
xp_findnextmsg
xp_grantlogin
xp_logevent
xp_loginconfig
xp_logininfo
xp_msver
xp_readmail
xp_revokelogin
xp_sendmail
xp_sprintf
xp_sqlagent_proxy_account
xp_sqlmaint
xp_sscanf
xp_startmail
xp_stopmail