Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.sp_MSdrop_rlcore

  No additional text.


Syntax
create procedure sys.sp_MSdrop_rlcore
as

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    if object_id('sp_MSmerge_getgencount','P') is not NULL
        drop procedure sp_MSmerge_getgencount

    if object_id('sp_MSmerge_parsegenlist','P') is not NULL
        drop procedure sp_MSmerge_parsegenlist

    if object_id('sp_MSadjustgenerations','P') is not NULL
        drop procedure sp_MSadjustgenerations


 
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