Friday, August 20, 2004

Undocumented SQL SP's

Every MS product has features beyond exploitation and more beyond documentation

Here is one such stored procedure, which is undocumented but is very useful for developers:

sp_MSforeachtable (T-SQL)

Syntax

sp_MSforeachtable[@command1 =] 'sql_command'
[, [@replacechar =] 'replacement_character']
[, [@command2 =] 'sql_command']
[, [@command3 =] 'sql_command']
[, [@whereand =] 'sql_command']
[, [@precommand =] 'sql_command']
[, [@postcommand =] 'sql_command']

Arguments

[@command1 =] 'sql_command'
Is the sql command to apply to each user table with the replacement_character where the table name would normally be placed. 'sql_command' is nvarchar(2000)*, varchar(255)+ with no default.

[, [@replacechar =] 'replacement_character']
Is the wild card character that will be replaced with each user table name. replacement_character is char(1) with a default of '?'

[, [@command2 =] 'sql_command']
Is the continuation of the sql command entered in @command1 to apply to each user table with the replacement_character where the table name would normally be placed. sql_command is nvarchar(2000)*, varchar(255)+ with a default of NULL. (Note: This parameter is not as useful on 7.0 since there are 4000 characters available in @command1)

[, [@command3 =] 'sql_command']
Is the continuation of the sql command entered in @command2 to apply to each user table with the replacement_character where the table name would normally be placed. 'sql_command' is nvarchar(2000)*, varchar(255)+ with a default of NULL. (Note: This parameter is not as useful on 7.0 since there are 4000 characters available in @command1)

[, [@whereand =] 'sql_command']
Is an additional where clause to limit the result set of the user table select. sql_command is nvarchar(2000)*, varchar(255)+ with a default of NULL. No wild card replacement occurs. It is added to the select that retrieves the user tables as passed to the procedure. It MUST be a valid where clause for a select against sysobjects.

[, [@precommand =] 'sql_command']
Is the sql command to be executed once before @command1 is processed. sql_command is nvarchar(2000)*, varchar(255)+ with a default of NULL. No wild card replacement occurs. It is executed as passed to the procedure.

[, [@postcommand =] 'sql_command']
Is the sql command to be executed once after @command1 is processed. sql_command is nvarchar(2000)*, varchar(255)+ with a default of NULL. No wild card replacement occurs. It is executed as passed to the procedure.

Return Code Values
0 (success) or @@ERROR (failure)
Result Sets

sp_MSforeachtable returns this message if no parameters are specified:

Procedure 'sp_MSforeachtable' expects parameter '@command1', which was not supplied.
Remarks

The procedure sp_MSforeachtable executes a set of commands against all the user tables in the current database. The sp_MSforeachtable procedure executes the precommand if entered. It then declares a cursor called hCForEach against sysobjects in the current database and passes the actual commands to be executed to sp_MSforeach_worker. The post command is then executed if entered.

Examples

Get the number of rows in each user table
sp_MSforeachtable 'print ''?'' select count(*) from ?'
sp_MSforeachtable 'select count(*) "?" from ?'

Grant SELECT permission to the developers on every user table
EXECUTE sp_MSforeachtable 'GRANT SELECT ON ? TO Developers'

Grant all permissions to the database maintenance role on every user meta data table
EXECUTE sp_MSforeachtable @command1 = 'PRINT ''?'' GRANT SELECT , INSERT , UPDATE , DELETE ON ? TO dbMaintenace', @whereand = 'AND name LIKE ''tbl%REF'' ORDER BY uid , name', @precommand = 'PRINT ''Granting permission on...''', @postcommand = 'PRINT ''Complete!'''

This is an exhaustive list of SQL Server undocumented stored procedures, yet to be explored by the world:

sp_MSchunkgeneration
sp_MSchunkgeneration
sp_MSgettools_path
sp_MSregistersubscription
sp_MSregistersubscription
sp_MSregistersubscription
sp_MS_upd_sysobj_category
sp_MSget_agent_names
sp_MSunregistersubscription
sp_MScleanup_conflict
sp_MSinit_replication_perfmon
sp_MSsubscription_enabled_for_syncmgr
sp_MSgetreplnick
sp_MSrepl_startup
sp_MSget_jobstate
sp_MSreplcheck_publish
sp_MShelpmergeconflictcounts
sp_MShelpmergeconflictcounts
sp_MSscriptmvastablenci
sp_MSflush_access_cache
sp_MSscript_pkvar_assignment
sp_MSscript_pkvar_assignment
sp_MSlocktable
sp_MShelpmergeconflictpublications
sp_MSscriptmvastablepkc
sp_MSreinit_failed_subscriptions
sp_MSreinit_failed_subscriptions
sp_MSget_publication_from_taskname
sp_MSenumcolumns
sp_MSclearcolumnbit
sp_MSscriptmvastableidx
sp_MSacquireHeadofQueueLock
sp_MSsetaccesslist
sp_MSscriptmvastable
sp_MSrepl_gettype_mappings
sp_MSacquireSlotLock
sp_MSreplcheck_pull
sp_MSreplcheck_pull
sp_MSreleaseSlotLock
sp_MSreplcheck_connection
sp_MSfix_6x_tasks
sp_MSfix_6x_tasks
sp_MSrepl_check_server
sp_MSrepl_PAL_rolecheck
sp_MShelpconflictpublications
sp_MSreset_synctran_bit
sp_MSreplcheck_qv
sp_MSenum_replsqlqueues
sp_MSenum_replqueues
sp_MSreplcheck_subscribe
sp_MScleanupmergepublisher
sp_MSreplicationcompatlevel
sp_MSaddpubtocontents
sp_MScleanupdynsnapshotvws
sp_MShelp_identity_property
sp_MShelp_identity_property
sp_MSget_subtypedatasrc
sp_MSpub_adjust_identity
sp_MSpub_adjust_identity
sp_MScleanupmergepublisherdb
sp_MScopysnapshot
sp_MScopysnapshot
sp_MSgenreplnickname
sp_MShelp_replication_table
sp_MSmergesubscribedb
sp_MScopyscriptfile
sp_MSenumallsubscriptions
sp_MSdrop_6x_replication_agent
sp_MSrepl_validate_dts_package
sp_MSenumsubscriptions
sp_MSenumsubscriptions
sp_MScomputemergearticlescreationorder
sp_MScomputemergearticlescreationorder
sp_MSreinit_article
sp_MSreinit_article
sp_MSget_load_hint
sp_MSenumallpublications
sp_MSenumallpublications
sp_MScomputemergeunresolvedrefs
sp_MScomputearticlescreationorder
sp_MScomputearticlescreationorder
sp_MSenumtranpublications
sp_MSCheckmergereplication
sp_MScomputeunresolvedrefs
sp_MSverifytranfilter
sp_MSenummergepublications
sp_MSgetpubinfo
sp_MShelptranconflictpublications
sp_MSenum3rdpartypublications
sp_MSaddmergedynamicsnapshotjob
sp_MSaddmergedynamicsnapshotjob
sp_MSaddmergedynamicsnapshotjob
sp_MShelptranconflictcounts
sp_MShelptranconflictcounts
sp_MSenumthirdpartypublicationvendornames
sp_MSdropmergedynamicsnapshotjob
sp_MSdropmergedynamicsnapshotjob
sp_MSgettranconflictrow
sp_MSagent_access_check
sp_MShelpmergedynamicsnapshotjob
sp_MSgettrancftsrcrow
sp_MSgettrancftsrcrow
sp_MSremove_userscript
sp_MSdeletetranconflictrow
sp_MSupdatesharedagentproperties
sp_MSupdatesharedagentproperties
sp_MSdrop_rlrecon
sp_MSdrop_rlrecon
sp_MSdrop_rlrecon
sp_MSdrop_rlrecon
sp_MSexternalfkreferences
sp_MSfetchidentityrange
sp_MSgetarticlereinitvalue
sp_MSfixupdistributorinfo
sp_MScheckidentityrange
sp_MSispkupdateinconflict
sp_MSfixupdistributorsecurity
sp_MShelpmergeidentity
sp_MSisnonpkukupdateinconflict
sp_MSrestore_sub_merge
sp_MSrestore_sub_merge
sp_MSrestore_sub_merge
sp_MSfixupftpinfo
sp_MShelpmergearticles
sp_MShelpmergearticles
sp_MShelpmergearticles
sp_MSrestore_sub_tran
sp_MSfixupaltsnapshotfolder
sp_MShelpmergeschemaarticles
sp_MSrestore_sub
sp_MSfixupworkingdirectory
sp_MScreateretry
sp_MSfixupuseftp
sp_MSdropretry
sp_MSprepare_sub_for_detach
sp_MSfixupagentoffloadinfo
sp_MSdroptemptable
sp_MSgetversion
sp_MSsub_check_identity
sp_MSfixupsharedagentproperties
sp_MSfixupsharedagentproperties
sp_MSchangearticleresolver
sp_MSpost_auto_proc
sp_MSsub_cleanup_orphans
sp_MSenumretries
sp_MSrepl_schema
sp_MSrepl_schema
sp_MSsub_cleanup_prop_table
sp_MSdeleteretry
sp_MSreplupdateschema
sp_MSreseed
sp_MSreseed
sp_MSaddlogin_implicit_ntlogin
sp_MSdeletepushagent
sp_MSdefer_check
sp_MSsub_set_identity
sp_MSget_pullsubsagent_owner
sp_MSgetonerow
sp_MSreenable_check
sp_MSinstance_qv
sp_MSuplineageversion
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSget_shared_agent
sp_MSgetlastrecgen
sp_MS_marksystemobject
sp_MSprep_exclusive
sp_MSdrop_pub_tables
sp_MSrepl_backup_start
sp_MStable_has_unique_index
sp_MSgetlastsentgen
sp_MSarticlecolstatus
sp_MSrepl_backup_complete
sp_MSchange_retention
sp_MSgetlastsentrecgens
sp_MSarticlecol
sp_MSadd_compensating_cmd
sp_MSadd_compensating_cmd
sp_MSchange_priority
sp_MSdummyupdate
sp_MSdummyupdate
sp_MScreate_pub_tables
sp_MScreate_pub_tables
sp_MScreate_pub_tables
sp_MScreate_pub_tables
sp_MSsetlastrecgen
sp_MSobjectprivs
sp_MSobjectprivs
sp_MSobjectprivs
sp_MSobjectprivs
sp_MSsetfilterparent
sp_MSsetlastsentgen
sp_MSdoesfilterhaveparent
sp_MSenumgenerations
sp_MSsetfilteredstatus
sp_MSget_setup_paths
sp_MScheckexistsgeneration
sp_MSdrop_rlcore
sp_MSdrop_rlcore
sp_MSretrieve_publication
sp_MSremoveoffloadparameter
sp_MSadduser_implicit_ntlogin
sp_MSchecksnapshotstatus
sp_MSguidtostr
sp_MSget_current_activity
sp_MSreplsup_table_has_pk
sp_MSaddoffloadparameter
sp_MScheck_uid_owns_anything
sp_MSget_mergepullsubsagent_owner
sp_MSenumreplicas
sp_MSgetconflicttablename
sp_MSset_current_activity
sp_MSset_current_activity
sp_MSenumdeletesmetadata
sp_MSuniqueobjectname
sp_MSobjsearch
sp_MSobjsearch
sp_MSobjsearch
sp_MSobjsearch
sp_MSUpgradeConflictTable
sp_MSUpgradeConflictTable
sp_MSreplraiserror
sp_MSenumpartialdeletes
sp_MSSetServerProperties
sp_MSuniquetempname
sp_MShasdbaccess
sp_MSsendtosqlqueue
sp_MSenumchanges
sp_MSsetalertinfo
sp_MSuniquecolname
sp_MSenumpartialchanges
sp_MSaddguidcolumn
sp_MShelpcolumns
sp_MShelpcolumns
sp_MShelpcolumns
sp_MShelpcolumns
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSpad_command
sp_MSinitdynamicsubscriber
sp_MSprepare_mergearticle
sp_MShelpindex
sp_MShelpindex
sp_MShelpindex
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSflush_command
sp_MSgetrowmetadata
sp_MSgetcolumnlist
sp_MShelptype
sp_MShelptype
sp_MSis_col_replicated
sp_MSis_col_replicated
sp_MSget_colinfo
sp_MSgetmetadatabatch
sp_MSaddguidindex
sp_MSdependencies
sp_MSdependencies
sp_MSdependencies
sp_MSdependencies
sp_MSdependencies
sp_MSdependencies
sp_MSdropfkreferencingarticle
sp_MSget_col_position
sp_MSsetrowmetadata
sp_MSrefcnt
sp_MStablespace
sp_MSget_map_position
sp_MSinsertgenhistory
sp_MSgentablenickname
sp_MSindexspace
sp_MSmergeupdatelastsyncinfo
sp_MSget_type
sp_MSupdategenhistory
sp_MStablenickname
sp_MStablerefs
sp_MStablerefs
sp_MStablerefs
sp_MSrepl_FixPALRole
sp_MSrepl_FixPALRole
sp_MSscript_where_clause
sp_MSscript_where_clause
sp_MSscript_where_clause
sp_MSlocalizeinterruptedgenerations
sp_MStablenamefromnick
sp_MStablekeys
sp_MStablekeys
sp_MStablekeys
sp_MStablekeys
sp_MStablekeys
sp_MSscript_params
sp_MSenumschemachange
sp_MSgetmakegenerationapplock
sp_MStablechecks
sp_MSscript_article_view
sp_MSsetcontext_replagent
sp_MSscript_procbodystart
sp_MSenumschemachange_70
sp_MSreleasemakegenerationapplock
sp_MSsettopology
sp_MSscript_begintrig1
sp_MSscript_begintrig1
sp_MSenumschemachange_80
sp_MSenumschemachange_80
sp_MSenumschemachange_80
sp_MSmakegeneration
sp_MSmakegeneration
sp_MSmakegeneration
sp_MSmakegeneration
sp_MSmatchkey
sp_MSaddexecarticle
sp_MSaddexecarticle
sp_MSaddexecarticle
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSscript_begintrig2
sp_MSscript_begintrig2
sp_MSenumschemachange_80sp3
sp_MSenumschemachange_80sp3
sp_MSenumschemachange_80sp3
sp_MSenumschemachange_80sp3
sp_MSfixlineageversions
sp_MSfixlineageversions
sp_MSforeach_worker
sp_MSforeach_worker
sp_MSaddschemaarticle
sp_MSaddschemaarticle
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MSscript_endtrig
sp_MSupdateschemachange
sp_MSaddupdatetrigger
sp_MSaddupdatetrigger
sp_MSaddupdatetrigger
sp_MSforeachdb
sp_MSscript_trigger_variables
sp_MSscript_trigger_variables
sp_MSremove_mergereplcommand
sp_MSaddmergetriggers
sp_MSaddmergetriggers
sp_MSaddmergetriggers
sp_MSaddmergetriggers
sp_MSforeachtable
sp_MSgettranconflictname
sp_MSIfExistsRemoteLogin
sp_MSscript_trigger_assignment
sp_MSadd_mergereplcommand
sp_MSadd_mergereplcommand
sp_MSchangeobjectowner
sp_MSloginmappings
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSscript_trigger_fetch_statement
sp_MSsetreplicainfo
sp_MShelpdestowner
sp_MScleanuptask
sp_MSuniquename
sp_MSreplrole
sp_MSscript_trigger_exec_rpc
sp_MSscript_trigger_exec_rpc
sp_MSscript_trigger_exec_rpc
sp_MSscript_trigger_exec_rpc
sp_MSsetreplicastatus
sp_MSfillupmissingcols
sp_MSkilldb
sp_MSscript_trigger_update_checks
sp_MScreateglobalreplica
sp_MScreateglobalreplica
sp_MSmaptype
sp_MSchangeschemaarticle
sp_MSchangeschemaarticle
sp_MShelpobjectpublications
sp_MSscript_trigger_updates
sp_MSsetconflictscript
sp_MSquerysubtype
sp_MSSQLDMO80_version
sp_MSscript_trigger_version_updates
sp_MSsetconflicttable
sp_MSSQLDMO70_version
sp_MSscript_singlerow_trigger
sp_MSmakeconflictinsertproc
sp_MSmakeconflictinsertproc
sp_MSmakeconflictinsertproc
sp_MSsethighestversion
sp_MSSQLOLE65_version
sp_MSscript_multirow_trigger
sp_MSmaketempinsertproc
sp_MSSQLOLE_version
sp_MSscript_sync_ins_trig
sp_MSgetconflictinsertproc
sp_MSgetconflictinsertproc
sp_MSpurgecontentsorphans
sp_MSscriptdatabase
sp_MSscript_sync_upd_trig
sp_MSinsertdeleteconflict
sp_MScleanup_zeroartnick_genhistory
sp_MSscriptdb_worker
sp_MSscript_sync_del_trig
sp_MScheckmetadatamatch
sp_MSdelete_specifiedcontents
sp_MSdbuseraccess
sp_MSdbuseraccess
sp_MSdbuseraccess
sp_MSget_synctran_column
sp_MSdelrow
sp_MSdelrow
sp_MSispulldistributionjobnamegenerated
sp_MSdrop_rladmin
sp_MSdrop_rladmin
sp_MSdrop_rladmin
sp_MSdrop_rladmin
sp_MSdbuserpriv
sp_MSdbuserpriv
sp_MSpublishdb
sp_MSsetartprocs
sp_MSsetartprocs
sp_MSispullmergejobnamegenerated
sp_MSaddmergepub_snapshot
sp_MSaddmergepub_snapshot
sp_MShelpfulltextindex
sp_MSactivate_auto_sub
sp_MSmakesystableviews
sp_MSmakesystableviews
sp_MSdropmergepub_snapshot
sp_MShelpfulltextscript
sp_MSget_synctran_commands
sp_MSget_synctran_commands
sp_MSget_synctran_commands
sp_MSget_synctran_commands
sp_MSgetchangecount
sp_MScheckatpublisher
sp_MSbelongs
sp_MSbelongs
sp_MSaddmergeschemaarticle
sp_MSaddmergeschemaarticle
sp_MSGetServerProperties
sp_MSaddpub_snapshot
sp_MSaddpub_snapshot
sp_MSexpandbelongs
sp_MSis_pk_col
sp_MScheck_agent_instance
sp_MSexpandnotbelongs
sp_MSchangemergeschemaarticle
sp_MSchangemergeschemaarticle
sp_MSSharedFixedDisk
sp_MSmark_proc_norepl
sp_MSBumpupCompLevel
sp_MSsetupbelongs_withoutviewproc
sp_MSfilterclause
sp_MSdrop_expired_subscription
sp_MSdrop_expired_subscription
sp_MSCleanupForPullReinit
sp_MSsetupnotbelongs
sp_MSadjustmergeidentity
sp_MSadjustmergeidentity
sp_MSgetalertinfo
sp_MSscript_validate_subscription
sp_MSpublicationcleanup
sp_MSpublicationcleanup
sp_MSsetupworktables
sp_MSsetupworktables
sp_MSsetupworktables
sp_MSvalidate_subscription
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MSsetupbelongs
sp_MSsetupbelongs
sp_MSsetupbelongs
sp_MSsetupbelongs
sp_MSdroparticleconstraints
sp_MSscript_insert_statement
sp_MSscript_insert_statement
sp_MSupdate_mqserver_distdb
sp_MSarticlecleanup
sp_MSarticlecleanup
sp_MSaddinitialarticle
sp_MSaddinitialarticle
sp_MSacquireserverresourcefordynamicsnapshot
sp_MSadd_distributor_alerts_and_responses
sp_MSadd_distributor_alerts_and_responses
sp_MSdroparticleprocs
sp_MSaddinitialschemaarticle
sp_MSscript_insert_subwins
sp_MSdrop_distributor_alerts_and_responses
sp_MSdrop_distributor_alerts_and_responses
sp_MSdroparticletriggers
sp_MSaddinitialpublication
sp_MSaddinitialpublication
sp_MSis_identity_insert
sp_MSaddinitialsubscription
sp_MSaddinitialsubscription
sp_MSscript_compensating_send
sp_MSmakearticleprocs
sp_MSgettranlastupdatedtime
sp_MSscriptinsertconflictfinder
sp_MSscriptinsertconflictfinder
sp_MSupdatesysmergearticles
sp_MSgetmergelastupdatedtime
sp_MSscript_insert_pubwins
sp_MSscript_insert_pubwins
sp_MSrepl_addrolemember
sp_MSexclause
sp_MSgetlastupdatedtime
sp_MSscript_update_statement
sp_MSscript_update_statement
sp_MSrepl_droprolemember
sp_MSgetcolordinalfromcolname
sp_MSreinitmergepublication
sp_MSinsertbeforeimageclause
sp_MSreinit_hub
sp_MSscript_update_subwins
sp_MScreatedupkeyupdatequery
sp_MScreatedupkeyupdatequery
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSmakeinsertproc
sp_MSmakeinsertproc
sp_MSmakeinsertproc
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSscript_update_pubwins
sp_MSscript_update_pubwins
sp_MSscript_update_pubwins
sp_MSremovedbreplication
sp_MSmakeupdateproc
sp_MSmakeupdateproc
sp_MSmakeupdateproc
sp_MSmakeupdateproc
sp_MSscript_delete_statement
sp_MSmakeselectproc
sp_MSmakeselectproc
sp_MSretrieve_mergepublication
sp_MSscript_delete_subwins
sp_MScopyregvalue
sp_MSdropconstraints
sp_MSscriptdelconflictfinder
sp_MSinsertschemachange
sp_MSreplcheckoffloadserver
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSgetviewcolumnlist
sp_MSscript_delete_pubwins
sp_MSvalidatearticle
sp_MSget_file_existence
sp_MShelpvalidationdate
sp_MSscript_beginproc
sp_MSsubscriptionvalidated
sp_MSrepl_isdbowner
sp_MSmergepublishdb
sp_MSscript_security
sp_MSdroparticletombstones
sp_MSscript_endproc
sp_MSproxiedmetadata
sp_MSget_qualified_name
sp_MStable_not_modifiable
sp_MSupdate_agenttype_default
sp_MScontractsubsnb
sp_MSdrop_object
sp_MSscript_ExecutionMode_stmt
sp_MSexpandsubsnb
sp_MSscript_sync_ins_proc
sp_MSvalidate_agent_parameter
sp_MSvalidate_agent_parameter
sp_MSvalidate_agent_parameter
sp_MSvalidate_agent_parameter
sp_MSvalidate_agent_parameter
sp_MSdelsubrows
sp_MSdelsubrows
sp_MSscript_sync_upd_proc
sp_MSdelsubrowsbatch
sp_MSdelsubrowsbatch
sp_MSdelsubrowsbatch
sp_MSdelsubrowsbatch
sp_MSsubst_filter_name
sp_MSscript_dri
sp_MSscript_sync_del_proc
sp_MSscriptviewproc
sp_MSscriptviewproc
sp_MSsubst_filter_names
sp_MSenumpubreferences
sp_MSscript_pub_upd_trig
sp_MSmakeviewproc
sp_MSreplcheck_name
sp_MSsubsetpublication
sp_MSmakeconflicttable
sp_MSmakeconflicttable
sp_MSmakeconflicttable
sp_MSget_publisher_rpc
sp_MScreatebeforetable
sp_MScheckvalidsystables
sp_MSindexcolfrombin
sp_MShelp_distdb
sp_MShelpcreatebeforetable
sp_MShelpcreatebeforetable
sp_MSdrop_mergesystables
sp_MSmakejoinfilter
sp_MSgen_sync_tran_procs
sp_MSgen_sync_tran_procs
sp_MSupdate_replication_status
sp_MSupdate_replication_status
sp_MSreset_queue
sp_MShelpalterbeforetable
sp_MShelpalterbeforetable
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MSmakeexpandproc
sp_MSmakeexpandproc
sp_MSmakeexpandproc
sp_MSenum_misc_agents
sp_MSreset_queued_reinit
sp_MSgetbeforetableinsert
sp_MStestbit
sp_MSdrop_expired_mergesubscription
sp_MSdrop_expired_mergesubscription
sp_MSload_replication_status
sp_MSinit_subscription_agent
sp_MSfixupbeforeimagetables
sp_MSsetbit
sp_MScleanup_metadata
sp_MScleanup_metadata
sp_msupg_removesystemcomputedcolumns
sp_MSareallcolumnscomputed
sp_MScreate_replication_status_table
sp_MSupdatelastsyncinfo
sp_MSreplcheck_permission
sp_MSinsertcontents
sp_MSgettypestringudt
sp_MShelp_replication_status
sp_MShelp_replication_status
sp_MSget_attach_state
sp_MSinserterrorlineage
sp_MSupdatecontents
sp_MSquiescecheck
sp_MSenum_replication_agents
sp_MSenum_replication_agents
sp_MSenum_replication_agents
sp_MSreset_attach_state
sp_MSevalsubscriberinfo
sp_MSdeletecontents
sp_MSset_subscription_properties
sp_MSsetsubscriberinfo
sp_MSunmarkifneeded
sp_MSpreparecleanup
sp_MSscript_missing_row_check
sp_MScreate_replication_checkup_agent
sp_MSset_sub_guid
sp_MSgetsubscriberinfo
sp_MSunmarkreplinfo
sp_MSquiescetriggerson
sp_msupg_recreatecatalogfaketables
sp_MSenum_replication_job
sp_MSmakectsview
sp_MSmakectsview
sp_MSmakectsview
sp_MSmarkreplinfo
sp_MSquiescetriggersoff
sp_msupg_dosystabcatalogupgrades
sp_msupg_dosystabcatalogupgrades
sp_msupg_dosystabcatalogupgrades
sp_MSrepl_dbrole
sp_MScreate_sub_tables
sp_MScreate_sub_tables
sp_MScreate_sub_tables
sp_MSinsertgenerationschemachanges
sp_MSinsertgenerationschemachanges
sp_MSunmarkschemaobject
sp_MSquiesceforcleanup
sp_msupg_dropcatalogcomputedcols
sp_MSupdate_mqserver_subdb
sp_MSalreadyhavegeneration
sp_MSmarkschemaobject
sp_msupg_createcatalogcomputedcols
sp_msupg_createcatalogcomputedcols
sp_msupg_createcatalogcomputedcols
sp_MS_replication_installed
sp_MSgettablecontents
sp_MSaddanonymousreplica
sp_MScompletecleanup
sp_MScompletecleanup
sp_msupg_recreatesystemviews
sp_MSget_oledbinfo
sp_MSunc_to_drive
sp_MSdelgenzero
sp_MSgetreplicainfo
sp_MSpropagateschematorepubs
sp_msupg_upgradecatalog
sp_MSretrieve_publication_attributes
sp_MSmakedynsnapshotvws
sp_MSmakedynsnapshotvws
sp_MSmakedynsnapshotvws
sp_MSmakedynsnapshotvws
sp_MSadd_repl_job
sp_MSadd_repl_job
sp_MSadd_repl_job
sp_MScleanup_publication_ADinfo
sp_MSdropdynsnapshotvws
sp_MScheck_subscription
sp_MScleanup_conflict_table
sp_MSrepl_linkedservers_rowset

No comments: