Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.sp_MSdrop_rladmin

  No additional text.


Syntax
create procedure sys.sp_MSdrop_rladmin
as
    if object_id('sp_MSaddmergepub_snapshot', 'P') is not NULL
        drop procedure sys.sp_MSaddmergepub_snapshot

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 
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