Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.sp_MSdrop_replcom

  No additional text.


Syntax
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

 
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