create procedure sys.sp_MSdrop_replcom
as
if object_id(N'sys.sp_MScreate_distributor_tables', 'P') is not null
drop procedure sys.sp_MScreate_distributor_tables
if object_id(N'sys.sp_MSrepl_drop_all_role_members', 'P') is not null
drop procedure sys.sp_MSrepl_drop_all_role_members
if object_id(N'sys.sp_MSrepl_clean_replication_bit', 'P') is not null
drop procedure sys.sp_MSrepl_clean_replication_bit
if object_id(N'sys.sp_MSIfExistsRemoteLogin', 'P') is not null
drop procedure sys.sp_MSIfExistsRemoteLogin
if object_id(N'sys.sp_helppublicationsync', 'P') is not null
drop procedure sys.sp_helppublicationsync
if object_id(N'sys.sp_addpublication_snapshot', 'P') is not null
drop procedure sys.sp_addpublication_snapshot
if object_id(N'sys.sp_MSrepl_addpublication_snapshot', 'P') is not null
drop procedure sys.sp_MSrepl_addpublication_snapshot
if object_id(N'sys.sp_changepublication_snapshot', 'P') is not null
drop procedure sys.sp_changepublication_snapshot
if object_id(N'sys.sp_MSrepl_changepublication_snapshot', 'P') is not null
drop procedure sys.sp_MSrepl_changepublication_snapshot
if object_id(N'sys.sp_MShelpobjectpublications', 'P') is not null
drop procedure sys.sp_MShelpobjectpublications
if object_id(N'sys.sp_addsubscriber', 'P') is not null
drop procedure sys.sp_addsubscriber
if object_id(N'sys.sp_MSrepl_addsubscriber', 'P') is not null
drop procedure sys.sp_MSrepl_addsubscriber
if object_id(N'sys.sp_MSadd_subserver', 'P') is not null
drop procedure sys.sp_MSadd_subserver
if object_id(N'sys.sp_addsubscriber_schedule', 'P') is not null
drop procedure sys.sp_addsubscriber_schedule
if object_id(N'sys.sp_changesubscriber_schedule', 'P') is not null
drop procedure sys.sp_changesubscriber_schedule
if object_id(N'sys.sp_MSrepl_changesubscriber_schedule', 'P') is not null
drop procedure sys.sp_MSrepl_changesubscriber_schedule
if object_id(N'sys.sp_changesubscriber', 'P') is not null
drop procedure sys.sp_changesubscriber
if object_id(N'sys.sp_MSrepl_changesubscriber', 'P') is not null
drop procedure sys.sp_MSrepl_changesubscriber
if object_id(N'sys.sp_MScreate_dist_tables', 'P') is not null
drop procedure sys.sp_MScreate_dist_tables
if object_id(N'sys.sp_MSupdate_mqserver_distdb', 'P') is not null
drop procedure sys.sp_MSupdate_mqserver_distdb
if object_id(N'sys.sp_distcounters', 'P') is not null
drop procedure sys.sp_distcounters
if object_id(N'sys.sp_MScreate_common_dist_tables', 'P') is not null
drop procedure sys.sp_MScreate_common_dist_tables
if object_id(N'sys.sp_droppublisher', 'P') is not null
drop procedure sys.sp_droppublisher
if object_id(N'sys.sp_dropsubscriber', 'P') is not null
drop procedure sys.sp_dropsubscriber
if object_id(N'sys.sp_MSrepl_dropsubscriber', 'P') is not null
drop procedure sys.sp_MSrepl_dropsubscriber
if object_id(N'sys.sp_MSdrop_subserver', 'P') is not null
drop procedure sys.sp_MSdrop_subserver
if object_id(N'sys.sp_MSDropCanClearSubscriberStatus', 'P') is not null
drop procedure sys.sp_MSDropCanClearSubscriberStatus
if object_id(N'sys.sp_dsninfo', 'P') is not null
drop procedure sys.sp_dsninfo
if object_id(N'sys.sp_enumdsn', 'P') is not null
drop procedure sys.sp_enumdsn
if object_id(N'sys.sp_helpdistributor', 'P') is not null
drop procedure sys.sp_helpdistributor
if object_id(N'sys.sp_MSrepl_getdistributorinfo', 'P') is not null
drop procedure sys.sp_MSrepl_getdistributorinfo
if object_id(N'sys.sp_MSdistributoravailable', 'P') is not null
drop procedure sys.sp_MSdistributoravailable
if object_id('sys.sp_helppublicationsync') is not null /* Remove old version */
drop procedure sys.sp_helppublicationsync
if object_id(N'sys.sp_helpreplicationdb', 'P') is not null
drop procedure sys.sp_helpreplicationdb
if object_id(N'sys.sp_helpsubscriberinfo', 'P') is not null
drop procedure sys.sp_helpsubscriberinfo
if object_id(N'sys.sp_MSrepl_helpsubscriberinfo', 'P') is not null
drop procedure sys.sp_MSrepl_helpsubscriberinfo
if object_id(N'sys.sp_publishdb', 'P') is not null
drop procedure sys.sp_publishdb
if object_id(N'sys.sp_replica', 'P') is not null
drop procedure sys.sp_replica
if object_id(N'sys.sp_adddistributiondb', 'P') is not null
drop procedure sys.sp_adddistributiondb
if object_id(N'sys.sp_changedistributiondb', 'P') is not null
drop procedure sys.sp_changedistributiondb
if object_id(N'sys.sp_helpdistributiondb', 'P') is not null
drop procedure sys.sp_helpdistributiondb
if object_id(N'sys.sp_MSrepl_DistributorReplMonitorAccess', 'P') is not null
drop procedure sys.sp_MSrepl_DistributorReplMonitorAccess
if object_id(N'sys.sp_MSrepl_DistributorPALAccess', 'P') is not null
drop procedure sys.sp_MSrepl_DistributorPALAccess
if object_id(N'sys.sp_MSrepl_DistDBPALAccess', 'P') is not null
drop procedure sys.sp_MSrepl_DistDBPALAccess
if object_id(N'sys.sp_dropdistributiondb', 'P') is not null
drop procedure sys.sp_dropdistributiondb
if object_id(N'sys.sp_adddistpublisher', 'P') is not null
drop procedure sys.sp_adddistpublisher
if object_id(N'sys.sp_MSrepl_adddistpublisher', 'P') is not null
drop procedure sys.sp_MSrepl_adddistpublisher
if object_id(N'sys.sp_IHaddpublisher', 'P') is not null
drop procedure sys.sp_IHaddpublisher
if object_id(N'sys.sp_changedistpublisher', 'P') is not null
drop procedure sys.sp_changedistpublisher
if object_id(N'sys.sp_helpdistpublisher', 'P') is not null
drop procedure sys.sp_helpdistpublisher
-- if object_id(N'sys.sp_MShelpdistpublisher', 'P') is not null
-- drop procedure sys.sp_MShelpdistpublisher
if object_id(N'sys.sp_dropdistpublisher', 'P') is not null
drop procedure sys.sp_dropdistpublisher
if object_id(N'sys.sp_IHdroppublisher', 'P') is not null
drop procedure sys.sp_IHdroppublisher
if object_id(N'sys.sp_MSadd_distributor_alerts_and_responses', 'P') is not null
drop procedure sys.sp_MSadd_distributor_alerts_and_responses
if object_id(N'sys.sp_MSdrop_distributor_alerts_and_responses', 'P') is not null
drop procedure sys.sp_MSdrop_distributor_alerts_and_responses
if object_id(N'sys.sp_adddistributor', 'P') is not null
drop procedure sys.sp_adddistributor
if object_id(N'sys.sp_dropdistributor', 'P') is not null
drop procedure sys.sp_dropdistributor
if object_id(N'sys.sp_changedistributor_property', 'P') is not null
drop procedure sys.sp_changedistributor_property
if object_id(N'sys.sp_helpdistributor_properties', 'P') is not null
drop procedure sys.sp_helpdistributor_properties
-- sp_helpsubscriber is removed permanently from the system.
if object_id(N'sys.sp_helpsubscriber', 'P') is not null
drop procedure sys.sp_helpsubscriber
-- sp_MSrepl_encrypt obsolete; use sp_MSreplencrypt
if object_id(N'sys.sp_MSrepl_encrypt', 'P') is not null
drop procedure sys.sp_MSrepl_encrypt
if object_id(N'sys.sp_add_agent_profile', 'P') is not null
drop procedure sys.sp_add_agent_profile
if object_id(N'sys.sp_help_agent_profile', 'P') is not null
drop procedure sys.sp_help_agent_profile
if object_id(N'sys.sp_help_agent_default', 'P') is not null
drop procedure sys.sp_help_agent_default
if object_id(N'sys.sp_drop_agent_profile', 'P') is not null
drop procedure sys.sp_drop_agent_profile
if object_id(N'sys.sp_MSupdate_agenttype_default', 'P') is not null
drop procedure sys.sp_MSupdate_agenttype_default
if object_id(N'sys.sp_MSvalidate_agent_parameter', 'P') is not null
drop procedure sys.sp_MSvalidate_agent_parameter
if object_id(N'sys.sp_add_agent_parameter', 'P') is not null
drop procedure sys.sp_add_agent_parameter
if object_id(N'sys.sp_generate_agent_parameter', 'P') is not null
drop procedure sys.sp_generate_agent_parameter
if object_id(N'sys.sp_change_agent_parameter', 'P') is not null
drop procedure sys.sp_change_agent_parameter
if object_id(N'sys.sp_MScache_agent_parameter', 'P') is not null
drop procedure sys.sp_MScache_agent_parameter
if object_id('sys.sp_MShelp_profilecache', 'P') is not null
drop procedure sys.sp_MShelp_profilecache
if object_id(N'sys.sp_change_agent_profile', 'P') is not null
drop procedure sys.sp_change_agent_profile
if object_id(N'sys.sp_help_agent_parameter', 'P') is not null
drop procedure sys.sp_help_agent_parameter
if object_id(N'sys.sp_drop_agent_parameter', 'P') is not null
drop procedure sys.sp_drop_agent_parameter
if object_id(N'sys.sp_MShelp_distdb', 'P') is not null
drop procedure sys.sp_MShelp_distdb
if object_id(N'sys.sp_MSenum_misc_agents', 'P') is not null
drop procedure sys.sp_MSenum_misc_agents
if object_id(N'sys.sp_MSload_tmp_replication_status', 'P') is not null
drop procedure sys.sp_MSload_tmp_replication_status
if object_id(N'sys.sp_MSenum_replication_status', 'P') is not null
drop procedure sys.sp_MSenum_replication_status
if object_id(N'sys.sp_MScreate_replication_status_table', 'P') is not null
drop procedure sys.sp_MScreate_replication_status_table
if object_id(N'sys.sp_MShelp_replication_status', 'P') is not null
drop procedure sys.sp_MShelp_replication_status
if object_id(N'sys.sp_MSenum_replication_agents', 'P') is not null
drop procedure sys.sp_MSenum_replication_agents
if object_id(N'sys.sp_replication_agent_checkup', 'P') is not null
drop procedure sys.sp_replication_agent_checkup
if object_id(N'sys.sp_MSreplrole', 'P') is not null
drop procedure sys.sp_MSreplrole
if object_id(N'sys.sp_MScreate_replication_checkup_agent', 'P') is not null
drop procedure sys.sp_MScreate_replication_checkup_agent
if object_id(N'sys.sp_MSreplhelp_jobhistory', 'P') is not null
drop procedure sys.sp_MSreplhelp_jobhistory
if object_id(N'sys.sp_MSenum_replication_job', 'P') is not null
drop procedure sys.sp_MSenum_replication_job
if object_id(N'sys.sp_MSrepl_dbrole', 'P') is not null
drop procedure sys.sp_MSrepl_dbrole
if object_id(N'sys.sp_oledbinfo', 'P') is not null
drop procedure sys.sp_oledbinfo
if object_id(N'sys.sp_enumoledbdatasources', 'P') is not null
drop procedure sys.sp_enumoledbdatasources
if object_id(N'sys.sp_MSget_oledbinfo', 'P') is not null
drop procedure sys.sp_MSget_oledbinfo
if object_id(N'sys.sp_changedistributor_password', 'P') is not null
drop procedure sys.sp_changedistributor_password
if object_id(N'sys.sp_grant_publication_access', 'P') is not null
drop procedure sys.sp_grant_publication_access
if object_id(N'sys.sp_revoke_publication_access', 'P') is not null
drop procedure sys.sp_revoke_publication_access
if object_id(N'sys.sp_help_publication_access', 'P') is not null
drop procedure sys.sp_help_publication_access
if object_id(N'sys.sp_MSinit_publication_access', 'P') is not null
drop procedure sys.sp_MSinit_publication_access
if object_id(N'sys.sp_MSpublication_access', 'P') is not null
drop procedure sys.sp_MSpublication_access
if object_id(N'sys.sp_check_publication_access', 'P') is not null
drop procedure sys.sp_check_publication_access
if object_id(N'sys.sp_MSinit_replication_perfmon', 'P') is not null
drop procedure sys.sp_MSinit_replication_perfmon
if object_id(N'sys.sp_MSrepl_startup_internal', 'P') is not null
drop procedure sys.sp_MSrepl_startup_internal
if object_id(N'sys.sp_MSflush_access_cache', 'P') is not null
drop procedure sys.sp_MSflush_access_cache
if object_id(N'sys.sp_MSreinit_failed_subscriptions', 'P') is not null
drop procedure sys.sp_MSreinit_failed_subscriptions
if object_id(N'sys.sp_add_datatype_mapping', 'P') is not null
drop procedure sys.sp_add_datatype_mapping
if object_id(N'sys.sp_help_datatype_mapping', 'P') is not null
drop procedure sys.sp_help_datatype_mapping
if object_id(N'sys.sp_MSrepl_gettype_mappings', 'P') is not null
drop procedure sys.sp_MSrepl_gettype_mappings
if object_id(N'sys.sp_MSfix_6x_tasks', 'P') is not null
drop procedure sys.sp_MSfix_6x_tasks
if object_id(N'sys.sp_MSget_agent_names', 'P') is not null
drop procedure sys.sp_MSget_agent_names
-- Common conflict viewer support procs
if object_id(N'sys.sp_MShelpconflictpublications', 'P') is not null
drop procedure sys.sp_MShelpconflictpublications
-- Procs for managing dynamic snapshot views
if object_id(N'sys.sp_MScleanupdynsnapshotvws', 'P') is not null
drop procedure sys.sp_MScleanupdynsnapshotvws
if object_id(N'sys.sp_MScleanupmergepublisher_internal', 'P') is not null
drop procedure sys.sp_MScleanupmergepublisher_internal
if object_id(N'sys.sp_MScleanupmergepublisherdb', 'P') is not null
drop procedure sys.sp_MScleanupmergepublisherdb
if object_id(N'sys.sp_MShelp_replication_table', 'P') is not null
drop procedure sys.sp_MShelp_replication_table
if object_id(N'sys.sp_MScopyscriptfile', 'P') is not null
drop procedure sys.sp_MScopyscriptfile
if object_id(N'sys.sp_MScopyscriptfile_merge', 'P') is not null
drop procedure sys.sp_MScopyscriptfile_merge
if object_id(N'sys.fn_replgetagentcommandlinefromjobid', 'FN') is not null
drop function sys.fn_replgetagentcommandlinefromjobid
if object_id(N'sys.fn_getpersistedservernamecasevariation', 'FN') is not null
drop function sys.fn_getpersistedservernamecasevariation
if object_id(N'sys.sp_MSrepl_getpublisherinfo', 'P') is not null
drop procedure sys.sp_MSrepl_getpublisherinfo
if object_id(N'sys.fn_MSrepl_ispublished', 'FN') is not null
drop function sys.fn_MSrepl_ispublished
if object_id(N'sys.fn_MSrepl_istranpublished', 'FN') is not null
drop function sys.fn_MSrepl_istranpublished
if object_id(N'sys.fn_MSrepl_ismergepublished', 'FN') is not null
drop function sys.fn_MSrepl_ismergepublished
if object_id(N'sys.fn_MSrepl_isdistdb', 'FN') is not null
drop function sys.fn_MSrepl_isdistdb
if object_id(N'sys.sp_MSrepl_IsLastPubInSharedSubscription', 'P') is not null
drop procedure sys.sp_MSrepl_IsLastPubInSharedSubscription
if object_id(N'sys.sp_MSrepl_enumpublications', 'P') is not null
drop procedure sys.sp_MSrepl_enumpublications
if object_id(N'sys.sp_MSrepl_enumsubscriptions', 'P') is not null
drop procedure sys.sp_MSrepl_enumsubscriptions
if object_id(N'sys.sp_MShelpsummarypublication', 'P') is not null
drop procedure sys.sp_MShelpsummarypublication
if object_id(N'sys.sp_publicationsummary', 'P') is not null
drop procedure sys.sp_publicationsummary
if object_id(N'sys.sp_MSrepl_publicationsummary', 'P') is not null
drop procedure sys.sp_MSrepl_publicationsummary
if object_id(N'sys.sp_MSrepl_agentstatussummary', 'P') is not null
drop procedure sys.sp_MSrepl_agentstatussummary
if object_id(N'sys.sp_subscriptionsummary', 'P') is not null
drop procedure sys.sp_subscriptionsummary
if object_id(N'sys.sp_MSrepl_subscriptionsummary', 'P') is not null
drop procedure sys.sp_MSrepl_subscriptionsummary
if object_id(N'sys.sp_MSrepl_distributionagentstatussummary', 'P') is not null
drop procedure sys.sp_MSrepl_distributionagentstatussummary
if object_id(N'sys.sp_mergesubscriptionsummary', 'P') is not null
drop procedure sys.sp_mergesubscriptionsummary
if object_id(N'sys.sp_MSrepl_mergeagentstatussummary', 'P') is not null
drop procedure sys.sp_MSrepl_mergeagentstatussummary
if object_id(N'sys.sp_replsetoriginator', 'P') is not null
drop procedure sys.sp_replsetoriginator
if object_id(N'sys.sp_replpostsyncstatus', 'P') is not null
drop procedure sys.sp_replpostsyncstatus
if object_id(N'sys.sp_replcleanupccsprocs', 'P') is not null
drop procedure sys.sp_replcleanupccsprocs
if object_id(N'sys.sp_replincrementlsn', 'P') is not null
drop procedure sys.sp_replincrementlsn
if object_id(N'sys.sp_MSrepl_incrementlsn', 'P') is not null
drop procedure sys.sp_MSrepl_incrementlsn
-- HREPL data type mapping procedures
if object_id(N'sys.fn_IHcompareversion', 'FN') is not null
drop function sys.fn_IHcompareversion
if object_id(N'sys.sp_MSrepl_getdbmsinfo', 'P') is not null
drop procedure sys.sp_MSrepl_getdbmsinfo
if object_id(N'sys.sp_MSrepl_setdefaultdatatype', 'P') is not null
drop procedure sys.sp_MSrepl_setdefaultdatatype
if object_id(N'sys.sp_MSrepl_fixupdefaultmappings', 'P') is not null
drop procedure sys.sp_MSrepl_fixupdefaultmappings
if object_id(N'sys.sp_MSrepl_checkdatatypemapping', 'P') is not null
drop procedure sys.sp_MSrepl_checkdatatypemapping
if object_id(N'sys.fn_MSrepl_checktype', 'FN') is not null
drop function sys.fn_MSrepl_checktype
if object_id(N'sys.fn_helpdatatypemap', 'TF') is not null
drop function sys.fn_helpdatatypemap
if object_id(N'sys.fn_MSrepl_getdatatypemappings', 'TF') is not null
drop function sys.fn_MSrepl_getdatatypemappings
if object_id(N'sys.fn_MSrepl_sourcetype', 'FN') is not null
drop function sys.fn_MSrepl_sourcetype
if object_id(N'sys.fn_IHgettypestring', 'FN') is not null
drop function sys.fn_IHgettypestring
if object_id(N'sys.sp_helpdatatypemap', 'P') is not null
drop procedure sys.sp_helpdatatypemap
if object_id(N'sys.sp_adddatatype', 'P') is not null
drop procedure sys.sp_adddatatype
if object_id(N'sys.sp_dropdatatype', 'P') is not null
drop procedure sys.sp_dropdatatype
if object_id(N'sys.sp_adddatatypemapping', 'P') is not null
drop procedure sys.sp_adddatatypemapping
if object_id(N'sys.sp_MSrepl_adddatatypemapping', 'P') is not null
drop procedure sys.sp_MSrepl_adddatatypemapping
if object_id(N'sys.sp_dropdatatypemapping', 'P') is not null
drop procedure sys.sp_dropdatatypemapping
if object_id(N'sys.sp_setdefaultdatatypemapping', 'P') is not null
drop procedure sys.sp_setdefaultdatatypemapping
if object_id(N'sys.sp_getdefaultdatatypemapping', 'P') is not null
drop procedure sys.sp_getdefaultdatatypemapping
if object_id(N'sys.sp_MSrepl_createdatatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_createdatatypemappings
if object_id(N'sys.sp_MSrepl_dropdatatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_dropdatatypemappings
if object_id(N'sys.sp_MSrepl_MSSQLdatatypes', 'P') is not null
drop procedure sys.sp_MSrepl_MSSQLdatatypes
if object_id(N'sys.sp_MSrepl_DB2datatypes', 'P') is not null
drop procedure sys.sp_MSrepl_DB2datatypes
if object_id(N'sys.sp_MSrepl_MSJetdatatypes', 'P') is not null
drop procedure sys.sp_MSrepl_MSJetdatatypes
if object_id(N'sys.sp_MSrepl_ORAdatatypes', 'P') is not null
drop procedure sys.sp_MSrepl_ORAdatatypes
if object_id(N'sys.sp_MSrepl_MSSQLdatatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_MSSQLdatatypemappings
if object_id(N'sys.sp_MSrepl_DB2datatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_DB2datatypemappings
if object_id(N'sys.sp_MSrepl_MSJetdatatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_MSJetdatatypemappings
if object_id(N'sys.sp_MSrepl_MSSSCEdatatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_MSSSCEdatatypemappings
if object_id(N'sys.sp_MSrepl_SASdatatypes', 'P') is not null
drop procedure sys.sp_MSrepl_SASdatatypes
if object_id(N'sys.sp_MSrepl_ORA_MSSQL_datatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_ORA_MSSQL_datatypemappings
if object_id(N'sys.sp_MSrepl_MSSQL_ORA_datatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_MSSQL_ORA_datatypemappings
if object_id(N'sys.sp_MSrepl_MSSQL_SAS_datatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_MSSQL_SAS_datatypemappings
if object_id(N'sys.sp_MSrepl_MSSQL_DB2_datatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_MSSQL_DB2_datatypemappings
if object_id(N'sys.sp_MSrepl_subdatatypemappings', 'P') is not null
drop procedure sys.sp_MSrepl_subdatatypemappings
-- HREPL RMO support procedures
if object_id(N'sys.sp_MSrepl_testconnection', 'P') is not null
drop procedure sys.sp_MSrepl_testconnection
if object_id(N'sys.sp_MSrepl_testadminconnection', 'P') is not null
drop procedure sys.sp_MSrepl_testadminconnection
if object_id(N'sys.sp_MSrepl_check_publisher', 'P') is not null
drop procedure sys.sp_MSrepl_check_publisher
if object_id(N'sys.sp_ORAcheckpublisher', 'P') is not null
drop procedure sys.sp_ORAcheckpublisher
if object_id(N'sys.sp_verifypublisher', 'P') is not null
drop procedure sys.sp_verifypublisher
if object_id(N'sys.sp_ORAverifypublisher', 'P') is not null
drop procedure sys.sp_ORAverifypublisher
if object_id(N'sys.sp_MSrepl_enumpublishertables', 'P') is not null
drop procedure sys.sp_MSrepl_enumpublishertables
if object_id(N'sys.sp_MSrepl_enumtablecolumninfo', 'P') is not null
drop procedure sys.sp_MSrepl_enumtablecolumninfo
if object_id(N'sys.sp_MSrepl_enumarticlecolumninfo', 'P') is not null
drop procedure sys.sp_MSrepl_enumarticlecolumninfo
if object_id(N'sys.sp_ORAenumpublishertables', 'P') is not null
drop procedure sys.sp_ORAenumpublishertables
if object_id(N'sys.sp_ORAenumtablecolumninfo', 'P') is not null
drop procedure sys.sp_ORAenumtablecolumninfo
if object_id(N'sys.sp_ORAenumarticlecolumninfo', 'P') is not null
drop procedure sys.sp_ORAenumarticlecolumninfo
if object_id(N'sys.fn_ORAenumarticlecolumninfo', 'TF') is not null
drop function sys.fn_ORAenumarticlecolumninfo
if object_id(N'sys.fn_ORAsourceinfo', 'FN') is not null
drop function sys.fn_ORAsourceinfo
if object_id(N'sys.fn_ORAgetbasetype', 'FN') is not null
drop function sys.fn_ORAgetbasetype
-- HREPL Oracle support sp's
if object_id(N'sys.sp_ORAaddpublisher', 'P') is not null
drop procedure sys.sp_ORAaddpublisher
if object_id(N'sys.sp_ORAloadscript', 'P') is not null
drop procedure sys.sp_ORAloadscript
if object_id(N'sys.sp_ORArowcount', 'P') is not null
drop procedure sys.sp_ORArowcount
if object_id(N'sys.sp_ORAcompiletriggers', 'P') is not null
drop procedure sys.sp_ORAcompiletriggers
if object_id(N'sys.sp_ORAremotequery', 'P') is not null
drop procedure sys.sp_ORAremotequery
if object_id(N'sys.sp_ORAgetversion', 'P') is not null
drop procedure sys.sp_ORAgetversion
-- HREPL support sp's
if object_id(N'sys.sp_IHCheckPublisherLogin', 'P') is not null
drop procedure sys.sp_IHCheckPublisherLogin
if object_id(N'sys.sp_IHgetversion', 'P') is not null
drop procedure sys.sp_IHgetversion
if object_id(N'sys.sp_IHgetprovider', 'P') is not null
drop procedure sys.sp_IHgetprovider
if object_id(N'sys.sp_ORAgetprovider', 'P') is not null
drop procedure sys.sp_ORAgetprovider
if object_id(N'sys.sp_IHquery', 'P') is not null
drop procedure sys.sp_IHquery
if object_id(N'sys.fn_IHview_name', 'FN') is not null
drop function sys.fn_IHview_name
if object_id(N'sys.fn_IHarticle_columns', 'FN') is not null
drop function sys.fn_IHarticle_columns
if object_id(N'sys.fn_IHpublished_columns', 'FN') is not null
drop function sys.fn_IHpublished_columns
if object_id(N'sys.fn_IHiscolpk', 'FN') is not null
drop function sys.fn_IHiscolpk
if object_id(N'sys.sp_IHexecresultset', 'P') is not null
drop procedure sys.sp_IHexecresultset
if object_id(N'sys.sp_IHisallreplcolpk', 'P') is not null
drop procedure sys.sp_IHisallreplcolpk
if object_id(N'sys.sp_IHisarticlecolbitset', 'P') is not null
drop procedure sys.sp_IHisarticlecolbitset
if object_id(N'sys.sp_IHget_colinfo', 'P') is not null
drop procedure sys.sp_IHget_colinfo
-- SPs that allow RMO/UI to get a list of all possible params for an agent type
if object_id(N'sys.sp_createagentparameterlist', 'P') is not null
drop procedure sys.sp_createagentparameterlist
if object_id(N'sys.sp_createagentparameter', 'P') is not null
drop procedure sys.sp_createagentparameter
if object_id(N'sys.sp_getagentparameterlist', 'P') is not null
drop procedure sys.sp_getagentparameterlist
if object_id(N'sys.fn_MSconstraint_columns') is not null
drop function sys.fn_MSconstraint_columns
if object_id(N'sys.fn_replcheckquotedname', 'FN') is not null
drop function sys.fn_replcheckquotedname
if object_id(N'sys.fn_replgetparsedddlcmd', 'FN') is not null
drop function sys.fn_replgetparsedddlcmd
if object_id(N'sys.sp_replgetparsedddlcmd', 'P') is not null
drop procedure sys.sp_replgetparsedddlcmd
if object_id(N'sys.fn_replremoveleadingcomments', 'FN') is not null
drop function sys.fn_replremoveleadingcomments
if object_id(N'sys.fn_replremovefullobj', 'FN') is not null
drop function sys.fn_replremovefullobj
if object_id(N'sys.sp_MSprocesspublisherlink', 'P') is not null
drop procedure sys.sp_MSprocesspublisherlink
if object_id(N'sys.fn_secondstohms', 'FN') is not null
drop function sys.fn_secondstohms
if object_id(N'sys.fn_replparsewindowslogin', 'TF') is not null
drop function sys.fn_replparsewindowslogin
if object_id(N'sys.fn_replisvalidwindowsloginformat', 'FN') is not null
drop function sys.fn_replisvalidwindowsloginformat
if object_id(N'sys.fn_yukonsecuritymodelrequired', 'FN') is not null
drop function sys.fn_yukonsecuritymodelrequired
if object_id(N'sys.sp_helppublication_snapshot', 'P') is not NULL
drop procedure sys.sp_helppublication_snapshot
if object_id(N'sys.sp_MSrepl_helppublication_snapshot', 'P') is not NULL
drop procedure sys.sp_MSrepl_helppublication_snapshot
if object_id(N'sys.sp_MSgetisvalidwindowsloginfromdistributor', 'P') is not NULL
drop procedure sys.sp_MSgetisvalidwindowsloginfromdistributor
if object_id(N'sys.sp_startpublication_snapshot', 'P') is not null
drop procedure sys.sp_startpublication_snapshot
if object_id(N'sys.sp_MSrepl_publicationsnapshotjobcontrol', 'P') is not null
drop procedure sys.sp_MSrepl_publicationsnapshotjobcontrol
if object_id(N'sys.sp_stoppublication_snapshot', 'P') is not null
drop procedure sys.sp_stoppublication_snapshot
if object_id(N'sys.sp_startpushsubscription_agent', 'P') is not null
drop procedure sys.sp_startpushsubscription_agent
if object_id(N'sys.sp_MSrepl_subscriptionagentjobcontrol', 'P') is not null
drop procedure sys.sp_MSrepl_subscriptionagentjobcontrol
if object_id(N'sys.sp_stoppushsubscription_agent', 'P') is not null
drop procedure sys.sp_stoppushsubscription_agent
if object_id(N'sys.sp_startmergepushsubscription_agent', 'P') is not null
drop procedure sys.sp_startmergepushsubscription_agent
if object_id(N'sys.sp_stopmergepushsubscription_agent', 'P') is not null
drop procedure sys.sp_stopmergepushsubscription_agent
if object_id(N'sys.sp_MSmergepushsubscriptionagentjobcontrol', 'P') is not null
drop procedure sys.sp_MSmergepushsubscriptionagentjobcontrol
if object_id(N'sys.sp_MSrepl_set_oracle_provider_inproc_on64bit', 'P') is not null
drop procedure sys.sp_MSrepl_set_oracle_provider_inproc_on64bit
if object_id(N'sys.sp_MSrepl_verify_oracle_provider_isregistered', 'P') is not null
drop procedure sys.sp_MSrepl_verify_oracle_provider_isregistered
if object_id(N'sys.sp_MSrepl_verify_oracle_client_version', 'P') is not null
drop procedure sys.sp_MSrepl_verify_oracle_client_version
if object_id(N'sys.fn_MSrepl_is_workgroup_edition', 'FN') is not null
drop function sys.fn_MSrepl_is_workgroup_edition
if object_id(N'sys.fn_MSrepl_editionid', 'FN') is not null
drop function sys.fn_MSrepl_editionid
if object_id(N'sys.sp_identitycolumnforreplication', 'P') is not null
drop procedure sys.sp_identitycolumnforreplication