Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.sp_MSdrop_repltran

  No additional text.


Syntax
create procedure sys.sp_MSdrop_repltran
as

   if object_id(N'sys.sp_MSsetfilterparent', 'P') is not null
		drop procedure sys.sp_MSsetfilterparent

    if object_id(N'sys.sp_MSdoesfilterhaveparent', 'P') is not null
		drop procedure sys.sp_MSdoesfilterhaveparent

    if object_id(N'sys.sp_MSsetfilteredstatus', 'P') is not null
		drop procedure sys.sp_MSsetfilteredstatus

    if object_id(N'sys.sp_MSreplsup_table_has_pk', 'P') is not null
		drop procedure sys.sp_MSreplsup_table_has_pk

    if object_id(N'sys.sp_MScreate_pub_tables', 'P') is not null
		drop procedure sys.sp_MScreate_pub_tables

    if object_id(N'sys.sp_MStran_ddlrepl', 'P') is not null
		drop procedure sys.sp_MStran_ddlrepl

    if object_id(N'sys.sp_MStran_altertable', 'P') is not null
		drop procedure sys.sp_MStran_altertable

    if object_id(N'sys.sp_MStran_alterview', 'P') is not null
		drop procedure sys.sp_MStran_alterview

    if object_id(N'sys.sp_MStran_alterschemaonly', 'P') is not null
		drop procedure sys.sp_MStran_alterschemaonly

    if object_id(N'sys.sp_MStran_altertrigger', 'P') is not null
		drop procedure sys.sp_MStran_altertrigger

    if object_id(N'sys.sp_MSdrop_expired_subscription', 'P') is not null
		drop procedure sys.sp_MSdrop_expired_subscription

    if object_id(N'sys.sp_MShelp_subscription_status', 'P') is not null
		drop procedure sys.sp_MShelp_subscription_status

    if object_id(N'sys.sp_replsync', 'P') is not null
		drop procedure sys.sp_replsync

    if object_id(N'sys.sp_enumfullsubscribers', 'P') is not null
		drop procedure sys.sp_enumfullsubscribers

    if object_id(N'sys.sp_MSrepl_enumfullsubscribers', 'P') is not null
		drop procedure sys.sp_MSrepl_enumfullsubscribers

    if object_id(N'sys.sp_MSaddexecarticle', 'P') is not null
		drop procedure sys.sp_MSaddexecarticle

    if object_id(N'sys.fn_replgetNumMergesubscriptionsOnPublication', 'FN') is not null
		drop function sys.fn_replgetNumMergesubscriptionsOnPublication
		
    if object_id(N'sys.fn_replgetNumMergesubscriptionsNowSyncingOnPublication', 'FN') is not null
		drop function sys.fn_replgetNumMergesubscriptionsNowSyncingOnPublication
		
    if object_id(N'sys.fn_replgetNumOfErrorsMergesubscriptionsOnPublication', 'FN') is not null
		drop function sys.fn_replgetNumOfErrorsMergesubscriptionsOnPublication
		
    if object_id(N'sys.fn_replgetNumOfWarningsMergesubscriptionsOnPublication', 'FN') is not null
		drop function sys.fn_replgetNumOfWarningsMergesubscriptionsOnPublication
		
    if object_id(N'sys.fn_replgetWorstWarningDurationMergesubscriptionsOnPublication', 'FN') is not null
		drop function sys.fn_replgetWorstWarningDurationMergesubscriptionsOnPublication
		
    if object_id(N'sys.fn_replgetWorstWarningExpirationMergesubscriptionsOnPublication', 'FN') is not null
		drop function sys.fn_replgetWorstWarningExpirationMergesubscriptionsOnPublication

    if object_id(N'sys.fn_replgetpublicationthreshold', 'FN') is not null
		drop function sys.fn_replgetpublicationthreshold

    if object_id(N'sys.fn_repltagcustomproc', 'FN') is not null
		drop function sys.fn_repltagcustomproc
		
    if object_id(N'sys.fn_repltranquotecustomproc', 'FN') is not null
		drop function sys.fn_repltranquotecustomproc

	if object_id(N'sys.fn_MSrepltranparsecmdtype') is not null
		drop function sys.fn_MSrepltranparsecmdtype
		
	if object_id(N'sys.fn_basecolsofcomputedpkcol') is not null
		drop function sys.fn_basecolsofcomputedpkcol

    if object_id(N'sys.fn_ispkcomputed') is not null
        drop function sys.fn_ispkcomputed

    if object_id(N'sys.fn_fcomputedpkimprecise') is not null
		drop function sys.fn_fcomputedpkimprecise

    if object_id(N'sys.fn_ftableivprocexec') is not null
		drop function sys.fn_ftableivprocexec

    if object_id(N'sys.fn_isxmlcolumn', 'FN') is not null
        drop function sys.fn_isxmlcolumn

	IF OBJECT_ID('sys.dm_repl_articles', 'IF') IS NOT NULL
		DROP function sys.dm_repl_articles

	IF OBJECT_ID('sys.dm_repl_schemas', 'IF') IS NOT NULL
		DROP function sys.dm_repl_schemas

	IF OBJECT_ID('sys.dm_repl_tranhash', 'IF') IS NOT NULL
		DROP function sys.dm_repl_tranhash

	IF OBJECT_ID('sys.dm_repl_traninfo', 'IF') IS NOT NULL
		DROP function sys.dm_repl_traninfo

	IF OBJECT_ID('sys.dm_repl_articles', 'V') IS NOT NULL
		DROP view sys.dm_repl_articles

	IF OBJECT_ID('sys.dm_repl_schemas', 'V') IS NOT NULL
		DROP view sys.dm_repl_schemas

	IF OBJECT_ID('sys.dm_repl_tranhash', 'V') IS NOT NULL
		DROP view sys.dm_repl_tranhash

	IF OBJECT_ID('sys.dm_repl_traninfo', 'V') IS NOT NULL
		DROP view sys.dm_repl_traninfo

    if object_id(N'sys.sp_MSSetLogForRepl', 'P') is not null
		drop procedure sys.sp_MSSetLogForRepl

    if object_id(N'sys.sp_addarticle', 'P') is not null
		drop procedure sys.sp_addarticle

    if object_id(N'sys.sp_MSrepl_addarticle', 'P') is not null
		drop procedure sys.sp_MSrepl_addarticle

    if object_id(N'sys.sp_IHaddarticle', 'P') is not null
		drop procedure sys.sp_IHaddarticle

    if object_id(N'sys.sp_IHsyncmetadata', 'P') is not null
        drop procedure sys.sp_IHsyncmetadata

    if object_id(N'sys.sp_IHflushmetadata', 'P') is not null
        drop procedure sys.sp_IHflushmetadata

    if object_id(N'sys.sp_checkOraclepackageversion', 'P') is not null
        drop procedure sys.sp_checkOraclepackageversion

    if object_id(N'sys.sp_MSrepl_checkOraclepackageversion', 'P') is not null
        drop procedure sys.sp_MSrepl_checkOraclepackageversion

    if object_id(N'sys.sp_setOraclepackageversion', 'P') is not null
        drop procedure sys.sp_setOraclepackageversion

    if object_id(N'sys.sp_MSrepl_setOraclepackageversion', 'P') is not null
        drop procedure sys.sp_MSrepl_setOraclepackageversion

    if object_id(N'sys.sp_getOraclepackageversion', 'P') is not null
        drop procedure sys.sp_getOraclepackageversion

    if object_id(N'sys.sp_MSrepl_getOraclepackageversion', 'P') is not null
        drop procedure sys.sp_MSrepl_getOraclepackageversion

    if object_id(N'sys.sp_MSaddschemaarticle', 'P') is not null
		drop procedure sys.sp_MSaddschemaarticle

    if object_id(N'sys.sp_MSchangeschemaarticle', 'P') is not null
		drop procedure sys.sp_MSchangeschemaarticle

    if object_id(N'sys.sp_MSgettranconflictname', 'P') is not null
		drop procedure sys.sp_MSgettranconflictname

    if object_id(N'sys.sp_MSretrieve_publication', 'P') is not null
		drop procedure sys.sp_MSretrieve_publication

    if object_id(N'sys.sp_MSmaketrancftproc', 'P') is not null
		drop procedure sys.sp_MSmaketrancftproc

    if object_id(N'sys.sp_articlecolumn', 'P') is not null
		drop procedure sys.sp_articlecolumn

    if object_id(N'sys.sp_MSrepl_articlecolumn', 'P') is not null
		drop procedure sys.sp_MSrepl_articlecolumn

    if object_id(N'sys.sp_IHarticlecolumn', 'P') is not null
		drop procedure sys.sp_IHarticlecolumn

    if object_id(N'sys.sp_IHarticleview', 'P') is not null
		drop procedure sys.sp_IHarticleview

    if object_id(N'sys.sp_changearticlecolumndatatype', 'P') is not null
		drop procedure sys.sp_changearticlecolumndatatype

    if object_id(N'sys.sp_MSrepl_changearticlecolumndatatype', 'P') is not null
		drop procedure sys.sp_MSrepl_changearticlecolumndatatype

    if object_id(N'sys.sp_articlefilter', 'P') is not null
		drop procedure sys.sp_articlefilter

    if object_id(N'sys.sp_MSrepl_articlefilter', 'P') is not null
		drop procedure sys.sp_MSrepl_articlefilter

    if object_id(N'sys.sp_MSarticlecol', 'P') is not null
		drop procedure sys.sp_MSarticlecol

    if object_id(N'sys.sp_MSarticlecolstatus', 'P') is not null
		drop procedure sys.sp_MSarticlecolstatus

    if object_id(N'sys.sp_MSscript_article_view', 'P') is not null
		drop procedure sys.sp_MSscript_article_view

    if object_id(N'sys.sp_articleview', 'P') is not null
		drop procedure sys.sp_articleview

    if object_id(N'sys.sp_MSrepl_articleview', 'P') is not null
		drop procedure sys.sp_MSrepl_articleview

    if object_id(N'sys.sp_MSget_latest_peerlsn') is not null
        drop procedure sys.sp_MSget_latest_peerlsn

    if object_id(N'sys.sp_addpublication', 'P') is not null
		drop procedure sys.sp_addpublication

    if object_id(N'sys.sp_MSrepl_addpublication', 'P') is not null
		drop procedure sys.sp_MSrepl_addpublication

	if object_id(N'sys.sp_IHaddpublication', 'P') is not null
		drop procedure sys.sp_IHaddpublication

    if object_id(N'sys.sp_addsubscription', 'P') is not null
		drop procedure sys.sp_addsubscription

    if object_id(N'sys.sp_MSrepl_addsubscription', 'P') is not null
		drop procedure sys.sp_MSrepl_addsubscription

    if object_id(N'sys.sp_MSrepl_addsubscription_article', 'P') is not null
		drop procedure sys.sp_MSrepl_addsubscription_article

    if object_id(N'sys.sp_changearticle', 'P') is not null
		drop procedure sys.sp_changearticle

    if object_id(N'sys.sp_MSrepl_changearticle', 'P') is not null
		drop procedure sys.sp_MSrepl_changearticle

    if object_id(N'sys.sp_changepublication', 'P') is not null
		drop procedure sys.sp_changepublication

    if object_id(N'sys.sp_MSrepl_changepublication', 'P') is not null
		drop procedure sys.sp_MSrepl_changepublication

    if object_id(N'sys.sp_changesubscription', 'P') is not null
		drop procedure sys.sp_changesubscription

    if object_id(N'sys.sp_MSrepl_changesubscription', 'P') is not null
		drop procedure sys.sp_MSrepl_changesubscription

	if object_id(N'sys.sp_enable_heterogeneous_subscription', 'P') is not null
		drop procedure sys.sp_enable_heterogeneous_subscription

    if object_id(N'sys.sp_MSrepl_enable_heterogeneous_subscription', 'P') is not null
		drop procedure sys.sp_MSrepl_enable_heterogeneous_subscription
		
    if object_id(N'sys.sp_MSrepl_enable_articles_for_het_sub', 'P') is not null
		drop procedure sys.sp_MSrepl_enable_articles_for_het_sub

    if object_id(N'sys.sp_MShcchangesubstatus1', 'P') is not null
		drop procedure sys.sp_MShcchangesubstatus1

    if object_id(N'sys.sp_MShcchangesubstatus2', 'P') is not null
		drop procedure sys.sp_MShcchangesubstatus2

    if object_id(N'sys.sp_MShcchangesubstatus3', 'P') is not null
		drop procedure sys.sp_MShcchangesubstatus3

    if object_id(N'sys.sp_changesubstatus', 'P') is not null
		drop procedure sys.sp_changesubstatus

    if object_id(N'sys.sp_MSrepl_changesubstatus', 'P') is not null
		drop procedure sys.sp_MSrepl_changesubstatus

    if object_id(N'sys.sp_droparticle', 'P') is not null
		drop procedure sys.sp_droparticle

    if object_id(N'sys.sp_MSrepl_droparticle', 'P') is not null
		drop procedure sys.sp_MSrepl_droparticle

	if object_id(N'sys.sp_IHdroparticle', 'P') is not null
		drop procedure sys.sp_IHdroparticle

    if object_id(N'sys.sp_droppublication', 'P') is not null
		drop procedure sys.sp_droppublication

    if object_id(N'sys.sp_MSrepl_droppublication', 'P') is not null
		drop procedure sys.sp_MSrepl_droppublication

	if object_id(N'sys.sp_IHdroppublication', 'P') is not null
		drop procedure sys.sp_IHdroppublication

    if object_id(N'sys.sp_MSdroptranpalrole', 'P') is not null
        drop procedure sys.sp_MSdroptranpalrole

    if object_id(N'sys.sp_dropsubscription', 'P') is not null
		drop procedure sys.sp_dropsubscription

    if object_id(N'sys.sp_MSrepl_dropsubscription', 'P') is not null
		drop procedure sys.sp_MSrepl_dropsubscription

    if object_id(N'sys.sp_helparticle', 'P') is not null
		drop procedure sys.sp_helparticle

    if object_id(N'sys.sp_MSrepl_helparticlermo', 'P') is not null
		drop procedure sys.sp_MSrepl_helparticlermo

    if object_id(N'sys.sp_MSrepl_helparticle', 'P') is not null
		drop procedure sys.sp_MSrepl_helparticle

    if object_id(N'sys.sp_IHhelparticle', 'P') is not null
		drop procedure sys.sp_IHhelparticle

    if object_id(N'sys.sp_ORAhelparticle', 'P') is not null
		drop procedure sys.sp_ORAhelparticle

    if object_id(N'sys.sp_helparticlecolumns', 'P') is not null
		drop procedure sys.sp_helparticlecolumns

    if object_id(N'sys.sp_MSrepl_snapshot_helparticlecolumns', 'P') is not null
		drop procedure sys.sp_MSrepl_snapshot_helparticlecolumns

    if object_id(N'sys.sp_MSrepl_helparticlecolumns', 'P') is not null
		drop procedure sys.sp_MSrepl_helparticlecolumns

    if object_id(N'sys.sp_helppublication', 'P') is not null
		drop procedure sys.sp_helppublication

    if object_id(N'sys.sp_MSrepl_helppublication', 'P') is not null
		drop procedure sys.sp_MSrepl_helppublication

    if object_id(N'sys.sp_IHhelppublication', 'P') is not null
		drop procedure sys.sp_IHhelppublication

    if object_id(N'sys.sp_MSrepl_snapshot_helppublication', 'P') is not null
		drop procedure sys.sp_MSrepl_snapshot_helppublication

    if object_id(N'sys.sp_MSaddpub_snapshot', 'P') is not null
		drop procedure sys.sp_MSaddpub_snapshot

	if object_id(N'sys.sp_helpsubscription', 'P') is not null
		drop procedure sys.sp_helpsubscription

	if object_id(N'sys.sp_MSrepl_helpsubscription', 'P') is not null
		drop procedure sys.sp_MSrepl_helpsubscription

    if object_id(N'sys.sp_subscribe', 'P') is not null
		drop procedure sys.sp_subscribe

    if object_id(N'sys.sp_unsubscribe', 'P') is not null
		drop procedure sys.sp_unsubscribe

    if object_id(N'sys.sp_refreshsubscriptions', 'P') is not null
		drop procedure sys.sp_refreshsubscriptions

    if object_id(N'sys.sp_MSrepl_refreshsubscriptions', 'P') is not null
		drop procedure sys.sp_MSrepl_refreshsubscriptions

    if object_id(N'sys.sp_MSpublishdb', 'P') is not null
		drop procedure sys.sp_MSpublishdb

    if object_id(N'sys.sp_MSactivate_auto_sub', 'P') is not null
		drop procedure sys.sp_MSactivate_auto_sub

    if object_id(N'sys.sp_MSarticle_synctran_commands', 'P') is not null
		drop procedure sys.sp_MSarticle_synctran_commands

    if object_id(N'sys.sp_MSget_synctran_commands', 'P') is not null
		drop procedure sys.sp_MSget_synctran_commands

    if object_id('sys.sp_MSdrop_pub_tables') is not null
    begin
        -- Don't drop the system tables here. repltran.sql should not
        -- delete any data in the master database.
        -- exec sys.sp_MSdrop_pub_tables
        -- rmak: Once everything is moved to the resource database, the
        -- above comment shouldn't be applicable anymore, but then again
        -- there is no need to drop any tables in the resource database
        -- either.
        drop procedure sys.sp_MSdrop_pub_tables
    end

    -- SyncTran
	if object_id(N'sys.sp_MSis_col_replicated', 'P') is not null
		drop procedure sys.sp_MSis_col_replicated

	if object_id(N'sys.fn_MSis_col_replicated', 'FN') is not null
		drop function sys.fn_MSis_col_replicated

	if object_id(N'sys.sp_MSis_pk_col', 'P') is not null
		drop procedure sys.sp_MSis_pk_col

	if object_id(N'sys.sp_MSscript_compensating_send', 'P') is not null
		drop procedure sys.sp_MSscript_compensating_send

	if object_id(N'sys.sp_MSscriptinsertconflictfinder', 'P') is not null
		drop procedure sys.sp_MSscriptinsertconflictfinder

	if object_id(N'sys.sp_MSscript_insert_statement', 'P') is not null
		drop procedure sys.sp_MSscript_insert_statement

	if object_id(N'sys.sp_script_insertforcftresolution', 'P') is not null
		drop procedure sys.sp_script_insertforcftresolution

	if object_id(N'sys.sp_MSscript_insert_subwins', 'P') is not null
		drop procedure sys.sp_MSscript_insert_subwins

	if object_id(N'sys.sp_MSscript_insert_pubwins', 'P') is not null
		drop procedure sys.sp_MSscript_insert_pubwins

	if object_id(N'sys.sp_MSvalidate_subscription', 'P') is not null
		drop procedure sys.sp_MSvalidate_subscription

	if object_id(N'sys.sp_MSscript_update_statement', 'P') is not null
		drop procedure sys.sp_MSscript_update_statement

	if object_id(N'sys.sp_scriptpubwinsrefreshcursorvars', 'P') is not null
		drop procedure sys.sp_scriptpubwinsrefreshcursorvars

	if object_id(N'sys.sp_MSscript_update_subwins', 'P') is not null
		drop procedure sys.sp_MSscript_update_subwins

	if object_id(N'sys.sp_MSscriptupdateconflictfinder', 'P') is not null
		drop procedure sys.sp_MSscriptupdateconflictfinder

	if object_id(N'sys.sp_MSscript_update_pubwins', 'P') is not null
		drop procedure sys.sp_MSscript_update_pubwins

	if object_id(N'sys.sp_MSscript_delete_statement', 'P') is not null
		drop procedure sys.sp_MSscript_delete_statement

	if object_id(N'sys.sp_MSscript_delete_subwins', 'P') is not null
		drop procedure sys.sp_MSscript_delete_subwins

	if object_id(N'sys.sp_MSscriptdelconflictfinder', 'P') is not null
		drop procedure sys.sp_MSscriptdelconflictfinder

	if object_id(N'sys.sp_MSscript_compensating_insert', 'P') is not null
		drop procedure sys.sp_MSscript_compensating_insert

	if object_id(N'sys.sp_MSscript_delete_pubwins', 'P') is not null
		drop procedure sys.sp_MSscript_delete_pubwins

	if object_id(N'sys.sp_MSscript_beginproc', 'P') is not null
		drop procedure sys.sp_MSscript_beginproc

	if object_id(N'sys.sp_MSscript_endproc', 'P') is not null
		drop procedure sys.sp_MSscript_endproc

	if object_id(N'sys.sp_MStable_not_modifiable', 'P') is not null
		drop procedure sys.sp_MStable_not_modifiable

	if object_id(N'sys.sp_MSscript_ExecutionMode_stmt', 'P') is not null
		drop procedure sys.sp_MSscript_ExecutionMode_stmt

	if object_id(N'sys.sp_MSscript_sync_ins_proc', 'P') is not null
		drop procedure sys.sp_MSscript_sync_ins_proc

	if object_id(N'sys.sp_MSscript_sync_upd_proc', 'P') is not null
		drop procedure sys.sp_MSscript_sync_upd_proc

	if object_id(N'sys.sp_MSscript_sync_del_proc', 'P') is not null
		drop procedure sys.sp_MSscript_sync_del_proc

	if object_id(N'sys.sp_MSscript_pub_upd_trig', 'P') is not null
		drop procedure sys.sp_MSscript_pub_upd_trig

	if object_id(N'sys.sp_MSmakeconflicttable', 'P') is not null
		drop procedure sys.sp_MSmakeconflicttable

	if object_id(N'sys.sp_scriptsubconflicttable', 'P') is not null
		drop procedure sys.sp_scriptsubconflicttable

	if object_id(N'sys.sp_MSgen_sync_tran_procs', 'P') is not null
		drop procedure sys.sp_MSgen_sync_tran_procs

	if object_id(N'sys.sp_MSis_identity_insert', 'P') is not null
		drop procedure sys.sp_MSis_identity_insert

	if object_id(N'sys.sp_MSmark_proc_norepl', 'P') is not null
		drop procedure sys.sp_MSmark_proc_norepl

	if object_id(N'sys.sp_articlesynctranprocs', 'P') is not null
		drop procedure sys.sp_articlesynctranprocs

	if object_id(N'sys.sp_reinitsubscription', 'P') is not null
		drop procedure sys.sp_reinitsubscription

	if object_id(N'sys.sp_MSrepl_reinitsubscription', 'P') is not null
		drop procedure sys.sp_MSrepl_reinitsubscription

    if object_id(N'sys.sp_MSareallcolpkcomputed', 'P') is not null
		drop procedure sys.sp_MSareallcolpkcomputed

    if object_id(N'sys.fn_gettypestring', 'FN') is not null
		drop function sys.fn_gettypestring

	if object_id(N'sys.fn_MSrepl_dependUDT') is not null
		drop function sys.fn_MSrepl_dependUDT

	if object_id(N'sys.fn_MStran_foreignkey') is not null
		drop function sys.fn_MStran_foreignkey

	if object_id(N'sys.fn_MStran_unique', 'FN') is not null
		drop function sys.fn_MStran_unique

    if object_id(N'sys.sp_scriptpkwhereclause', 'P') is not null
		drop procedure sys.sp_scriptpkwhereclause

    if object_id(N'sys.sp_MSscript_missing_row_check', 'P') is not null
		drop procedure sys.sp_MSscript_missing_row_check

    if object_id(N'sys.sp_scriptupdateparams', 'P') is not null
		drop procedure sys.sp_scriptupdateparams

    if object_id(N'sys.sp_scriptreconwhereclause', 'P') is not null
		drop procedure sys.sp_scriptreconwhereclause

    if object_id(N'sys.sp_scriptinsproccore', 'P') is not null
		drop procedure sys.sp_scriptinsproccore

    if object_id(N'sys.sp_script_reconciliation_insproc', 'P') is not null
		drop procedure sys.sp_script_reconciliation_insproc

	if object_id(N'sys.sp_script_reconciliation_sinsproc', 'P') is not null
		drop procedure sys.sp_script_reconciliation_sinsproc

    if object_id(N'sys.sp_script_reconciliation_delproc', 'P') is not null
		drop procedure sys.sp_script_reconciliation_delproc

    if object_id(N'sys.sp_script_reconciliation_xdelproc', 'P') is not null
		drop procedure sys.sp_script_reconciliation_xdelproc

    if object_id(N'sys.sp_script_reconciliation_vdelproc', 'P') is not null
		drop procedure sys.sp_script_reconciliation_vdelproc

    if object_id(N'sys.sp_MSscriptcustominsproc', 'P') is not null
		drop procedure sys.sp_MSscriptcustominsproc

    if object_id(N'sys.sp_MSscriptcustomdelproc', 'P') is not null
		drop procedure sys.sp_MSscriptcustomdelproc

    if object_id(N'sys.sp_MSscriptcustomupdproc', 'P') is not null
		drop procedure sys.sp_MSscriptcustomupdproc

    if object_id(N'sys.sp_register_custom_scripting', 'P') is not null
		drop procedure sys.sp_register_custom_scripting

    if object_id(N'sys.sp_unregister_custom_scripting', 'P') is not null
		drop procedure sys.sp_unregister_custom_scripting

    if object_id(N'sys.sp_scriptinsproc', 'P') is not null
		drop procedure sys.sp_scriptinsproc

	if object_id(N'sys.sp_scriptsinsproc', 'P') is not null
		drop procedure sys.sp_scriptsinsproc

    if object_id(N'sys.sp_scriptdelproccore', 'P') is not null
		drop procedure sys.sp_scriptdelproccore

    if object_id(N'sys.sp_scriptdelproc', 'P') is not null
		drop procedure sys.sp_scriptdelproc

    if object_id(N'sys.sp_scriptvdelproc', 'P') is not null
		drop procedure sys.sp_scriptvdelproc

    if object_id(N'sys.sp_scriptxdelproc', 'P') is not null
		drop procedure sys.sp_scriptxdelproc

    if object_id(N'sys.sp_scriptupdproc', 'P') is not null
		drop procedure sys.sp_scriptupdproc

    if object_id(N'sys.sp_scriptxupdproc', 'P') is not null
		drop procedure sys.sp_scriptxupdproc

	if object_id(N'sys.sp_scriptsupdproc', 'P') is not null
		drop procedure sys.sp_scriptsupdproc

    if object_id(N'sys.sp_scriptmappedupdproc', 'P') is not null
		drop procedure sys.sp_scriptmappedupdproc

    if object_id(N'sys.sp_scriptdynamicupdproc', 'P') is not null
	        drop procedure sys.sp_scriptdynamicupdproc

    if object_id(N'sys.sp_scriptvupdproc', 'P') is not null
		drop procedure sys.sp_scriptvupdproc

    if object_id(N'sys.sp_scriptupdproccore', 'P') is not null
		drop procedure sys.sp_scriptupdproccore

    if object_id(N'sys.sp_MSscriptmvastablenci', 'P') is not null
		drop procedure sys.sp_MSscriptmvastablenci

    if object_id(N'sys.sp_MSscriptmvastablepkc', 'P') is not null
		drop procedure sys.sp_MSscriptmvastablepkc

    if object_id(N'sys.sp_MSscriptmvastableidx', 'P') is not null
		drop procedure sys.sp_MSscriptmvastableidx

    if object_id(N'sys.sp_MSscriptmvastable', 'P') is not null
		drop procedure sys.sp_MSscriptmvastable

    if object_id(N'sys.sp_browsereplcmds', 'P') is not null
		drop procedure sys.sp_browsereplcmds

    if object_id(N'sys.sp_replshowcmds', 'P') is not null
		drop procedure sys.sp_replshowcmds

    if object_id(N'sys.sp_publication_validation', 'P') is not null
		drop procedure sys.sp_publication_validation

    if object_id(N'sys.sp_MSpublication_validation', 'P') is not null
		drop procedure sys.sp_MSpublication_validation

    if object_id(N'sys.sp_marksubscriptionvalidation', 'P') is not null
		drop procedure sys.sp_marksubscriptionvalidation

    if object_id(N'sys.sp_MSmarksubscriptionvalidation', 'P') is not null
		drop procedure sys.sp_MSmarksubscriptionvalidation

    if object_id(N'sys.sp_article_validation', 'P') is not null
		drop procedure sys.sp_article_validation

    if object_id(N'sys.sp_MSarticle_validation', 'P') is not null
		drop procedure sys.sp_MSarticle_validation

    if object_id(N'sys.sp_MSdrop_6x_replication_agent', 'P') is not null
		drop procedure sys.sp_MSdrop_6x_replication_agent

    if object_id(N'sys.sp_MSget_article_column_list', 'P') is not null
		drop procedure sys.sp_MSget_article_column_list

    if object_id(N'sys.sp_MSpub_adjust_identity', 'P') is not null
		drop procedure sys.sp_MSpub_adjust_identity

    if object_id(N'sys.sp_helparticledts', 'P') is not null
		drop procedure sys.sp_helparticledts

    if object_id(N'sys.sp_changesubscriptiondtsinfo', 'P') is not null
		drop procedure sys.sp_changesubscriptiondtsinfo

    if object_id(N'sys.sp_script_synctran_commands', 'P') is not null
		drop procedure sys.sp_script_synctran_commands

    if object_id(N'sys.sp_MShelptranconflictpublications', 'P') is not null
		drop procedure sys.sp_MShelptranconflictpublications

    if object_id(N'sys.sp_MShelptranconflictcounts', 'P') is not null
		drop procedure sys.sp_MShelptranconflictcounts

    if object_id(N'sys.sp_MSgettranconflictrow', 'P') is not null
		drop procedure sys.sp_MSgettranconflictrow

    if object_id(N'sys.sp_MSgettrancftsrcrow', 'P') is not null
		drop procedure sys.sp_MSgettrancftsrcrow

    if object_id(N'sys.sp_MSdeletetranconflictrow', 'P') is not null
		drop procedure sys.sp_MSdeletetranconflictrow

    if object_id(N'sys.sp_MSgetpeerconflictrow', 'P') is not null
		drop procedure sys.sp_MSgetpeerconflictrow

    if object_id(N'sys.sp_MSgetpeerwinnerrow', 'P') is not null
		drop procedure sys.sp_MSgetpeerwinnerrow

    if object_id(N'sys.sp_MSdeletepeerconflictrow', 'P') is not null
		drop procedure sys.sp_MSdeletepeerconflictrow

    if object_id(N'sys.sp_MSgetarticlereinitvalue', 'P') is not null
		drop procedure sys.sp_MSgetarticlereinitvalue

    if object_id(N'sys.sp_MSispkupdateinconflict', 'P') is not null
		drop procedure sys.sp_MSispkupdateinconflict

    if object_id(N'sys.sp_MSisnonpkukupdateinconflict', 'P') is not null
		drop procedure sys.sp_MSisnonpkukupdateinconflict

    if object_id(N'sys.sp_dropanonymousagent', 'P') is not null
		drop procedure sys.sp_dropanonymousagent

    if object_id(N'sys.sp_ivindexhasnullcols', 'P') is not null
		drop procedure sys.sp_ivindexhasnullcols

    if object_id(N'sys.sp_replrestart', 'P') is not null
		drop procedure sys.sp_replrestart

    if object_id(N'sys.sp_MSreinit_article', 'P') is not null
		drop procedure sys.sp_MSreinit_article

    if object_id(N'sys.sp_replqueuemonitor', 'P') is not null
		drop procedure sys.sp_replqueuemonitor

    if object_id(N'sys.sp_replsqlqgetrows', 'P') is not null
		drop procedure sys.sp_replsqlqgetrows

    if object_id(N'sys.sp_MSrepl_schema', 'P') is not null
		drop procedure sys.sp_MSrepl_schema

    if object_id(N'sys.sp_MStran_autoproc', 'P') is not null
		drop procedure sys.sp_MStran_autoproc

    if object_id(N'sys.sp_MSpost_auto_proc', 'P') is not null
		drop procedure sys.sp_MSpost_auto_proc

    if object_id(N'sys.sp_MSreplupdateschema', 'P') is not null
		drop procedure sys.sp_MSreplupdateschema

    if object_id(N'sys.sp_MSLockMatchID', 'P') is not null
		drop procedure sys.sp_MSLockMatchID

    if object_id(N'sys.sp_MSdefer_check', 'P') is not null
		drop procedure sys.sp_MSdefer_check

    if object_id(N'sys.sp_MSreenable_check', 'P') is not null
		drop procedure sys.sp_MSreenable_check

    if object_id(N'sys.sp_getqueuedrows', 'P') is not null
		drop procedure sys.sp_getqueuedrows

    if object_id(N'sys.sp_MSprep_exclusive', 'P') is not null
		drop procedure sys.sp_MSprep_exclusive

    if object_id(N'sys.sp_scriptpublicationcustomprocs', 'P') is not null
		drop procedure sys.sp_scriptpublicationcustomprocs

    if object_id(N'sys.sp_MSrepl_scriptpublicationcustomprocs', 'P') is not null
		drop procedure sys.sp_MSrepl_scriptpublicationcustomprocs

    if object_id(N'sys.sp_MSenableobjectsreplication', 'P') is not null
		drop procedure sys.sp_MSenableobjectsreplication

    if object_id(N'sys.sp_MSactivatelogbasedarticleobject', 'P') is not null
        drop procedure sys.sp_MSactivatelogbasedarticleobject

    if object_id(N'sys.sp_MSactivateprocedureexecutionarticleobject', 'P') is not null
        drop procedure sys.sp_MSactivateprocedureexecutionarticleobject

    if object_id(N'sys.sp_MSdodatabasesnapshotinitiation', 'P') is not null
		drop procedure sys.sp_MSdodatabasesnapshotinitiation

    if object_id(N'sys.sp_MSdopartialdatabasesnapshotinitiation', 'P') is not null
		drop procedure sys.sp_MSdopartialdatabasesnapshotinitiation

    if object_id(N'sys.sp_MSenableautonosync', 'P') is not null
		drop procedure sys.sp_MSenableautonosync

    if object_id(N'sys.sp_MSdisableautonosync', 'P') is not null
		drop procedure sys.sp_MSdisableautonosync

    if object_id(N'sys.sp_MSincrementpublicationminautonosynclsn', 'P') is not null
		drop procedure sys.sp_MSincrementpublicationminautonosynclsn

    if object_id(N'sys.sp_MSsetupnosyncsubscriptionwithlsn', 'P') is not null
		drop procedure sys.sp_MSsetupnosyncsubscriptionwithlsn

    if object_id(N'sys.sp_MSaddautonosyncsubscription', 'P') is not null
		drop procedure sys.sp_MSaddautonosyncsubscription

    if object_id(N'sys.sp_MSgeneratenosyncsubscriptionsetupscript', 'P') is not null
		drop procedure sys.sp_MSgeneratenosyncsubscriptionsetupscript

    if object_id(N'sys.sp_MSscriptpublicationcustomprocs', 'P') is not null
		drop procedure sys.sp_MSscriptpublicationcustomprocs

    if object_id(N'sys.sp_scriptpublicationcustomprocs', 'P') is not null
		drop procedure sys.sp_scriptpublicationcustomprocs

    if object_id(N'sys.sp_MSextractlastlsnfrombackup', 'P') is not null
		drop procedure sys.sp_MSextractlastlsnfrombackup

    if object_id(N'sys.sp_MSdumpscripttabletonvarcharmax', 'P') is not null
        drop procedure sys.sp_MSdumpscripttabletonvarcharmax

    if object_id(N'sys.fn_replreplacesinglequote', 'FN') is not null
		drop function sys.fn_replreplacesinglequote

    if object_id(N'sys.fn_replreplacesinglequoteplusprotectstring', 'FN') is not null
		drop function sys.fn_replreplacesinglequoteplusprotectstring

    if object_id(N'sys.fn_sqlvarbasetostr', 'FN') is not null
		drop function sys.fn_sqlvarbasetostr

    if object_id(N'sys.fn_varbintohexsubstring', 'FN') is not null
		drop function sys.fn_varbintohexsubstring

    if object_id(N'sys.fn_varbintohexstr', 'FN') is not null
		drop function sys.fn_varbintohexstr

    if object_id(N'sys.fn_replgetbitmapfromcolid', 'FN') is not null
		drop function sys.fn_replgetbitmapfromcolid

    if object_id('sys.sp_MSscriptpublicationconflicttables', 'P') is not null
        drop procedure sys.sp_MSscriptpublicationconflicttables

    if object_id('sys.sp_repltablehasnonpkuniquekey', 'P') is not null
        drop procedure sys.sp_repltablehasnonpkuniquekey

    if object_id('sys.sp_replscriptuniquekeywhereclause', 'P') is not null
        drop procedure sys.sp_replscriptuniquekeywhereclause

    if object_id('sys.sp_repldeletequeuedtran', 'P') is not null
        drop procedure sys.sp_repldeletequeuedtran

    if object_id('sys.sp_getqueuedarticlesynctraninfo', 'P') is not null
        drop procedure sys.sp_getqueuedarticlesynctraninfo

    if object_id('sys.sp_getsqlqueueversion', 'P') is not null
        drop procedure sys.sp_getsqlqueueversion

    
    -- Heterogenous replication specific sp's
    

	if object_id(N'sys.sp_IHadd_sync_command', 'P') is not null
		drop procedure sys.sp_IHadd_sync_command

	if object_id(N'sys.sp_IHreplflush', 'P') is not null
		drop procedure sys.sp_IHreplflush

	if object_id(N'sys.sp_IHreplincrementlsn', 'P') is not null
		drop procedure sys.sp_IHreplincrementlsn

	if object_id(N'sys.fn_IHgetpubid', 'TF') is not null
		drop function sys.fn_IHgetpubid

	if object_id(N'sys.fn_MSrepl_getpubid', 'FN') is not null
		drop function sys.fn_MSrepl_getpubid

    if object_id(N'sys.fn_IHGenerateUniqueName', 'FN') is not null
		drop function sys.fn_IHGenerateUniqueName

	if object_id(N'sys.fn_IHPublicationIsTransactional', 'FN') is not null
		drop function sys.fn_IHPublicationIsTransactional

    if object_id(N'sys.sp_IHgetPublicationInfo', 'P') is not null
		drop procedure sys.sp_IHgetPublicationInfo

    if object_id(N'sys.sp_IHgetPublisherInfo', 'P') is not null
		drop procedure sys.sp_IHgetPublisherInfo

    if object_id(N'sys.sp_IHCheckSourceTable', 'P') is not null
		drop procedure sys.sp_IHCheckSourceTable

    if object_id(N'sys.sp_IHVerifyIndex', 'P') is not null
		drop procedure sys.sp_IHVerifyIndex

    if object_id(N'sys.sp_IHVerifyConstraint', 'P') is not null
		drop procedure sys.sp_IHVerifyConstraint

    if object_id(N'sys.sp_IHGenerateUniqueName', 'P') is not null
		drop procedure sys.sp_IHGenerateUniqueName

	if object_id(N'sys.sp_IHarticle_validation', 'P') is not null
		drop procedure sys.sp_IHarticle_validation

	if object_id(N'sys.sp_IHpublication_validation', 'P') is not null
		drop procedure sys.sp_IHpublication_validation

	if object_id(N'sys.sp_IHmarksubscriptionvalidation', 'P') is not null
		drop procedure sys.sp_IHmarksubscriptionvalidation

	if object_id(N'sys.sp_IH_LR_GetCacheData', 'P') is not null
		drop procedure sys.sp_IH_LR_GetCacheData
		
    if object_id(N'sys.sp_IHget_loopback_detection', 'P') is not null
		drop procedure sys.sp_IHget_loopback_detection

    if object_id(N'sys.sp_getsubscription_status_hsnapshot', 'P') is not null
		drop procedure sys.sp_getsubscription_status_hsnapshot

    if object_id(N'sys.sp_get_Oracle_publisher_metadata', 'P') is not null
		drop procedure sys.sp_get_Oracle_publisher_metadata

    if object_id(N'sys.sp_MSrepl_get_Oracle_publisher_metadata', 'P') is not null
		drop procedure sys.sp_MSrepl_get_Oracle_publisher_metadata
		
    if object_id(N'sys.sp_MSrepl_get_Oracle_publisher_table', 'P') is not null
		drop procedure sys.sp_MSrepl_get_Oracle_publisher_table
		
    if object_id(N'sys.sp_log_repository_message', 'P') is not null
		drop procedure sys.sp_log_repository_message
		
    if object_id(N'sys.sp_MSrepl_getsubscription_status_hsnapshot', 'P') is not null
		drop procedure sys.sp_MSrepl_getsubscription_status_hsnapshot

    if object_id(N'sys.sp_distagentstatus', 'P') is not null
		drop procedure sys.sp_distagentstatus

	
	-- Heterogeneous scripting
	

	if object_id(N'sys.sp_IHScriptIdxFile', 'P') is not null
		drop procedure sys.sp_IHScriptIdxFile

	if object_id(N'sys.sp_IHScriptSchFile', 'P') is not null
		drop procedure sys.sp_IHScriptSchFile

	if object_id(N'sys.sp_IHscriptindexes', 'P') is not null
		drop procedure sys.sp_IHscriptindexes

	if object_id(N'sys.sp_IHscriptprimarykey', 'P') is not null
		drop procedure sys.sp_IHscriptprimarykey

	if object_id(N'sys.sp_IHscripttable', 'P') is not null
		drop procedure sys.sp_IHscripttable

	if object_id(N'sys.sp_IHscriptupdateparams', 'P') is not null
		drop procedure sys.sp_IHscriptupdateparams
	
	if object_id(N'sys.sp_IHscriptpkwhereclause', 'P') is not null
		drop procedure sys.sp_IHscriptpkwhereclause
	
	if object_id(N'sys.sp_IHscriptreconwhereclause', 'P') is not null
		drop procedure sys.sp_IHscriptreconwhereclause
	
	if object_id(N'sys.sp_IHscript_missing_row_check', 'P') is not null
		drop procedure sys.sp_IHscript_missing_row_check

	if object_id(N'sys.sp_schemafilter', 'P') is not null
		drop procedure sys.sp_schemafilter

	if object_id(N'sys.sp_validatecache', 'P') is not null
		drop procedure sys.sp_validatecache

	if object_id(N'sys.sp_MSrepl_validatecache', 'P') is not null
		drop procedure sys.sp_MSrepl_validatecache

	if object_id(N'sys.sp_publisherproperty', 'P') is not null
		drop procedure sys.sp_publisherproperty

	if object_id(N'sys.sp_IHXactSetJob', 'P') is not null
		drop procedure sys.sp_IHXactSetJob

	if object_id(N'sys.sp_helpxactsetjob', 'P') is not null
		drop procedure sys.sp_helpxactsetjob

	if object_id(N'sys.sp_IHValidateRowFilter', 'P') is not null
		drop procedure sys.sp_IHValidateRowFilter

	
	-- Oracle replication specific sp's
	
	
    if object_id(N'sys.sp_ORACheckSourceTable', 'P') is not null
		drop procedure sys.sp_ORACheckSourceTable

    if object_id(N'sys.sp_ORACheckAdminPrivileges', 'P') is not null
		drop procedure sys.sp_ORACheckAdminPrivileges

    if object_id(N'sys.sp_CheckOracleAdminPrivileges', 'P') is not null
		drop procedure sys.sp_CheckOracleAdminPrivileges

    if object_id(N'sys.sp_ORACheckLoopbackSupport', 'P') is not null
		drop procedure sys.sp_ORACheckLoopbackSupport
	
    if object_id(N'sys.sp_ORASchemaFilter', 'P') is not null
		drop procedure sys.sp_ORASchemaFilter

    if object_id(N'sys.sp_ORAGetTablespaceInfo', 'P') is not null
		drop procedure sys.sp_ORAGetTablespaceInfo

    if object_id(N'sys.sp_ORAChangeTableSpace', 'P') is not null
		drop procedure sys.sp_ORAChangeTableSpace

    if object_id(N'sys.sp_ORAvalidatecache', 'P') is not null
		drop procedure sys.sp_ORAvalidatecache

	if object_id(N'sys.sp_ORAXactSetJob', 'P') is not null
		drop procedure sys.sp_ORAXactSetJob

	if object_id(N'sys.sp_ORAhelpXactSetJob', 'P') is not null
		drop procedure sys.sp_ORAhelpXactSetJob
		
	if object_id(N'sys.sp_ORASetXactBatching', 'P') is not null
		drop procedure sys.sp_ORASetXactBatching

	if object_id(N'sys.sp_ORAhelpXactBatching', 'P') is not null
		drop procedure sys.sp_ORAhelpXactBatching

	if object_id(N'sys.sp_ORAValidateRowFilter', 'P') is not null
		drop procedure sys.sp_ORAValidateRowFilter

	if object_id(N'sys.sp_ORAmarksubscriptionvalidation', 'P') is not null
		drop procedure sys.sp_ORAmarksubscriptionvalidation

	if object_id(N'sys.sp_ORAaddpublication', 'P') is not null
		drop procedure sys.sp_ORAaddpublication

	if object_id(N'sys.sp_ORAgetcolumndata', 'P') is not null
		drop procedure sys.sp_ORAgetcolumndata

	if object_id(N'sys.sp_ORAaddarticle', 'P') is not null
		drop procedure sys.sp_ORAaddarticle

	if object_id(N'sys.sp_ORAdroppublisher', 'P') is not null
		drop procedure sys.sp_ORAdroppublisher
		
	if object_id(N'sys.sp_ORAdroparticle', 'P') is not null
		drop procedure sys.sp_ORAdroparticle

	if object_id(N'sys.sp_ORAposttracertoken', 'P') is not null
		drop procedure sys.sp_ORAposttracertoken

	if object_id('sys.sp_posttracertoken', 'P') is not null
	    drop procedure sys.sp_posttracertoken
	
	if object_id('sys.sp_MSrepl_posttracertoken', 'P') is not null
	    drop procedure sys.sp_MSrepl_posttracertoken

	if object_id('sys.sp_helptracertokens', 'P') is not null
	    drop procedure sys.sp_helptracertokens

	if object_id('sys.sp_helptracertokenhistory', 'P') is not null
	    drop procedure sys.sp_helptracertokenhistory

	if object_id('sys.sp_deletetracertokenhistory', 'P') is not null
	    drop procedure sys.sp_deletetracertokenhistory

	if object_id('sys.sp_MSaddmqforsubscription', 'P') is not null
	    drop procedure sys.sp_MSaddmqforsubscription

	if object_id('sys.sp_MSdropmqforsubscription', 'P') is not null
	    drop procedure sys.sp_MSdropmqforsubscription

	if object_id('sys.sp_MScleanup_agent_entry', 'P') is not null
	    drop procedure sys.sp_MScleanup_agent_entry

    -- ui procedures moved from instdist

    if object_id('sys.sp_MShelp_publication', 'P') is not null
        drop procedure sys.sp_MShelp_publication

    if object_id('sys.sp_MShelp_profile', 'P') is not null
        drop procedure sys.sp_MShelp_profile

    if object_id('sys.sp_MScheck_pull_access', 'P') is not null
        drop procedure sys.sp_MScheck_pull_access

    -- extended procedures that should be in resource db
    if object_id('sys.xp_createprivatequeue','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_createprivatequeue'

    if object_id('sys.xp_deleteprivatequeue','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_deleteprivatequeue'

    if object_id('sys.sp_replsendtoqueue','local') is not null
		exec sys.sp_dropextendedproc 'sys.sp_replsendtoqueue'

    if object_id('sys.sp_replwritetovarbin','local') is not null
		exec sys.sp_dropextendedproc 'sys.sp_replwritetovarbin'

    if object_id('sys.xp_resetqueue','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_resetqueue'

    if object_id('sys.xp_peekqueue','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_peekqueue'

    if object_id('sys.xp_controlqueueservice','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_controlqueueservice'

    if object_id('sys.xp_displayqueuemesgs','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_displayqueuemesgs'

    if object_id('sys.xp_decodequeuecmd','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_decodequeuecmd'

    if object_id('sys.xp_readpkfromqueue','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_readpkfromqueue'

    if object_id('sys.xp_readpkfromvarbin','local') is not null
		exec sys.sp_dropextendedproc 'sys.xp_readpkfromvarbin'

	-- PeerToPeer replication specific procs
	if object_id(N'sys.sp_MSgetdbversion', 'P') is not null
		drop procedure sys.sp_MSgetdbversion

	if object_id(N'sys.sp_MSpeerdbinfo', 'P') is not null
		drop procedure sys.sp_MSpeerdbinfo

	if object_id(N'sys.sp_MSaddpeerlsn', 'P') is not null
		drop procedure sys.sp_MSaddpeerlsn
		
	if object_id(N'sys.sp_MSupdatepeerlsn', 'P') is not null
		drop procedure sys.sp_MSupdatepeerlsn

	if object_id(N'sys.sp_MSgetpeerlsns', 'P') is not null
		drop procedure sys.sp_MSgetpeerlsns

	if object_id(N'sys.sp_MSaddsubscriptionarticles', 'P') is not null
		drop procedure sys.sp_MSaddsubscriptionarticles

	if object_id(N'sys.sp_MSvalidatepeertopeerpublication', 'P') is not null
		drop procedure sys.sp_MSvalidatepeertopeerpublication

	if object_id(N'sys.sp_MSvalidatepeertopeerarticles', 'P') is not null
		drop procedure sys.sp_MSvalidatepeertopeerarticles

	if object_id(N'sys.sp_MSdetectinvalidpeerconfiguration', 'P') is not null
		drop procedure sys.sp_MSdetectinvalidpeerconfiguration

	if object_id(N'sys.sp_MSdetectinvalidpeersubscription', 'P') is not null
		drop procedure sys.sp_MSdetectinvalidpeersubscription

	if object_id(N'sys.sp_MSdetectinvalidaddarticle', 'P') is not null
		drop procedure sys.sp_MSdetectinvalidaddarticle
		
	if object_id(N'sys.sp_MSgetpeertopeercommands', 'P') is not null
		drop procedure sys.sp_MSgetpeertopeercommands
		
	if object_id(N'sys.sp_MSpeertopeerfwdingexec', 'P') is not null
		drop procedure sys.sp_MSpeertopeerfwdingexec

	if object_id(N'sys.sp_MSexecwithlsnoutput', 'P') is not NULL
		drop procedure sys.sp_MSexecwithlsnoutput
		
	if object_id(N'sys.sp_requestpeerresponse', 'P') is not NULL
		drop procedure sys.sp_requestpeerresponse

	if object_id(N'sys.sp_MSpeersendresponse', 'P') is not NULL
		drop procedure sys.sp_MSpeersendresponse

	if object_id(N'sys.sp_MSpeerapplyresponse', 'P') is not NULL
		drop procedure sys.sp_MSpeerapplyresponse

	if object_id(N'sys.sp_requestpeertopologyinfo', 'P') is not NULL
		drop procedure sys.sp_requestpeertopologyinfo

	if object_id(N'sys.sp_MSpeersendtopologyinfo', 'P') is not NULL
		drop procedure sys.sp_MSpeersendtopologyinfo

	if object_id(N'sys.sp_MSpeerapplytopologyinfo', 'P') is not NULL
		drop procedure sys.sp_MSpeerapplytopologyinfo

	if object_id(N'sys.sp_gettopologyinfo', 'P') is not NULL
		drop procedure sys.sp_gettopologyinfo

	if object_id(N'sys.sp_addlogreader_agent', 'P') is not NULL
		drop procedure sys.sp_addlogreader_agent

	if object_id(N'sys.sp_MSrepl_addlogreader_agent', 'P') is not NULL
		drop procedure sys.sp_MSrepl_addlogreader_agent

	if object_id(N'sys.sp_changelogreader_agent', 'P') is not NULL
		drop procedure sys.sp_changelogreader_agent
		
	if object_id(N'sys.sp_MSrepl_changelogreader_agent', 'P') is not NULL
		drop procedure sys.sp_MSrepl_changelogreader_agent

	if object_id(N'sys.sp_helplogreader_agent', 'P') is not NULL
			drop procedure sys.sp_helplogreader_agent

	if object_id(N'sys.sp_MSrepl_helplogreader_agent', 'P') is not NULL
		drop procedure sys.sp_MSrepl_helplogreader_agent
	
	if object_id('sys.sp_helppeerrequests', 'P') is not NULL
		drop procedure sys.sp_helppeerrequests

	if object_id('sys.sp_helppeerresponses', 'P') is not NULL
		drop procedure sys.sp_helppeerresponses

	if object_id('sys.sp_deletepeerrequesthistory', 'P') is not NULL
		drop procedure sys.sp_deletepeerrequesthistory

	if object_id('sys.sp_MScheckgenerate_originatorid', 'P') is not NULL
              drop procedure sys.sp_MScheckgenerate_originatorid

	if object_id('sys.sp_MSchange_originatorid', 'P') is not NULL
              drop procedure sys.sp_MSchange_originatorid

	if object_id('sys.sp_MSgetpeerconflictname', 'P') is not NULL
              drop procedure sys.sp_MSgetpeerconflictname

	if object_id('sys.fn_peerconflicttablename', 'FN') is not NULL
              drop function sys.fn_peerconflicttablename

	if object_id('sys.sp_MSmakepeerconflicttable', 'P') is not NULL
              drop procedure sys.sp_MSmakepeerconflicttable
		
	if object_id('sys.sp_configure_peerconflictdetection', 'P') is not NULL
		drop procedure sys.sp_configure_peerconflictdetection

	if object_id('sys.sp_MSscriptpeerconflictdetection_tableaug', 'P') is not NULL
		drop procedure sys.sp_MSscriptpeerconflictdetection_tableaug

	if object_id('sys.sp_peerconflictdetection_tableaug', 'P') is not NULL
		drop procedure sys.sp_peerconflictdetection_tableaug

	if object_id('sys.sp_MSscriptpeerconflictdetection_customprocs', 'P') is not NULL
		drop procedure sys.sp_MSscriptpeerconflictdetection_customprocs

	if object_id('sys.sp_help_peerconflictdetection', 'P') is not NULL
		drop procedure sys.sp_help_peerconflictdetection

	if object_id('sys.sp_MSpeerconflictdetection_topology_applyresponse', 'P') is not NULL
		drop procedure sys.sp_MSpeerconflictdetection_topology_applyresponse

	if object_id('sys.sp_MSscriptpeerconflictdetection_topology_sendresponse', 'P') is not NULL
		drop procedure sys.sp_MSscriptpeerconflictdetection_topology_sendresponse

	if object_id('sys.sp_MSpeerconflictdetection_topology_sendrequest', 'P') is not NULL
		drop procedure sys.sp_MSpeerconflictdetection_topology_sendrequest

	if object_id('sys.sp_MSpeerconflictdetection_statuscollection_applyresponse', 'P') is not NULL
		drop procedure sys.sp_MSpeerconflictdetection_statuscollection_applyresponse

	if object_id('sys.sp_MSpeerconflictdetection_statuscollection_sendresponse', 'P') is not NULL
		drop procedure sys.sp_MSpeerconflictdetection_statuscollection_sendresponse

	if object_id('sys.sp_MSpeerconflictdetection_statuscollection_sendrequest', 'P') is not NULL
		drop procedure sys.sp_MSpeerconflictdetection_statuscollection_sendrequest

	if object_id('sys.sp_replrethrow', 'P') is not NULL
		drop procedure sys.sp_replrethrow

	if object_id('sys.fn_replp2pversiontotranid', 'FN') is not NULL
              drop function sys.fn_replp2pversiontotranid

	if object_id('sys.fn_replvarbintoint', 'FN') is not NULL
              drop function sys.fn_replvarbintoint

	if object_id(N'sys.sp_addpushsubscription_agent', 'P') is not null
		drop procedure sys.sp_addpushsubscription_agent

	if object_id(N'sys.sp_MSrepl_addpushsubscription_agent', 'P') is not null
		drop procedure sys.sp_MSrepl_addpushsubscription_agent

	if object_id('sys.sp_MScleanup_peer_metadata', 'P') is not NULL
		drop procedure sys.sp_MScleanup_peer_metadata

	if object_id('sys.sp_scriptupdmoderefresh', 'P') is not NULL
		drop procedure sys.sp_scriptupdmoderefresh

	if object_id(N'sys.sp_setsubscriptionxactseqno', 'P') is not null
    	drop procedure sys.sp_setsubscriptionxactseqno

    if object_id(N'sys.sp_MSrepl_setNFR', 'P') is not null
    	drop procedure sys.sp_MSrepl_setNFR

	if object_id(N'sys.sp_refresh_heterogeneous_publisher', 'P') is not null
		drop procedure sys.sp_refresh_heterogeneous_publisher

	if object_id(N'sys.sp_MSrepl_refresh_heterogeneous_publisher', 'P') is not null
		drop procedure sys.sp_MSrepl_refresh_heterogeneous_publisher

    if object_id(N'sys.sp_MSgettransarticlecolumnlist', 'P') is not null
        drop procedure sys.sp_MSgettransarticlecolumnlist

    if object_id(N'sys.sp_MSdrop_synctran_objects', 'P') is not null
        drop procedure sys.sp_MSdrop_synctran_objects

    if object_id(N'sys.sp_MSissnapshotagentrunning', 'P') is not null
        drop procedure sys.sp_MSissnapshotagentrunning

	if object_id(N'sys.sp_replrethrow', 'P') is not null
		drop procedure sys.sp_replrethrow

	if object_id('sys.fn_replvarbintoint',  'FN') is not null
		drop function sys.fn_replvarbintoint

    if object_id('sys.sp_MScheckprocexec', 'P') is not null
        drop procedure sys.sp_MScheckprocexec

 
Last revision 2008RTM
News

  Query a named instance
Sybase+ASE+silent+install
SQL 2008 R2
Deprecated procedures in SQL2008
Reporting Services item-level role definitions
Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash