Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.sp_MSdrop_asm_tranrepl

  No additional text.


Syntax

create procedure sys.sp_MSdrop_asm_tranrepl
as
    if object_id('sp_printstatement') is not null
        drop procedure sys.sp_printstatement

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

    --if object_id('sp_readfile') is not null
    --    drop procedure sys.sp_readfile

    --if object_id('sp_MSserializerowset') is not null
    --    drop procedure sys.sp_MSserializerowset

    --if object_id('sp_execresultset_sqlclr') is not null
    --    drop procedure sys.sp_execresultset_sqlclr

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

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

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

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

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

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

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

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

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

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

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

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

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

    if object_id('ORMask') is not null
        drop aggregate sys.ORMask

    --Uncomment the following to enable the CLR version of sp_instdist
    --if object_id('sp_instdist') is not null
    --    drop procedure sys.sp_instdist

    if exists (select * from sys.assemblies where name = 'asm_tranrepl')
        drop assembly asm_tranrepl


 
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