Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.sp_MSdelrowsbatch

  No additional text.


Syntax

create procedure sys.sp_MSdelrowsbatch (
    @pubid uniqueidentifier,
    @tablenick  int,
    @check_permission int = 0,
    @rows_tobe_deleted int,
    @partition_id int = NULL,
    @rowguid1 uniqueidentifier,
    @metadata_type1 tinyint,
    @generation1 bigint,
    @lineage_old1 varbinary(311),
    @lineage_new1 varbinary(311),
    @rowguid2 uniqueidentifier = NULL,
    @metadata_type2 tinyint = NULL,
    @generation2 bigint = NULL,
    @lineage_old2 varbinary(311) = NULL,
    @lineage_new2 varbinary(311) = NULL,
    @rowguid3 uniqueidentifier = NULL,
    @metadata_type3 tinyint = NULL,
    @generation3 bigint = NULL,
    @lineage_old3 varbinary(311) = NULL,
    @lineage_new3 varbinary(311) = NULL,
    @rowguid4 uniqueidentifier = NULL,
    @metadata_type4 tinyint = NULL,
    @generation4 bigint = NULL,
    @lineage_old4 varbinary(311) = NULL,
    @lineage_new4 varbinary(311) = NULL,
    @rowguid5 uniqueidentifier = NULL,
    @metadata_type5 tinyint = NULL,
    @generation5 bigint = NULL,
    @lineage_old5 varbinary(311) = NULL,
    @lineage_new5 varbinary(311) = NULL,
    @rowguid6 uniqueidentifier = NULL,
    @metadata_type6 tinyint = NULL,
    @generation6 bigint = NULL,
    @lineage_old6 varbinary(311) = NULL,
    @lineage_new6 varbinary(311) = NULL,
    @rowguid7 uniqueidentifier = NULL,
    @metadata_type7 tinyint = NULL,
    @generation7 bigint = NULL,
    @lineage_old7 varbinary(311) = NULL,
    @lineage_new7 varbinary(311) = NULL,
    @rowguid8 uniqueidentifier = NULL,
    @metadata_type8 tinyint = NULL,
    @generation8 bigint = NULL,
    @lineage_old8 varbinary(311) = NULL,
    @lineage_new8 varbinary(311) = NULL,
    @rowguid9 uniqueidentifier = NULL,
    @metadata_type9 tinyint = NULL,
    @generation9 bigint = NULL,
    @lineage_old9 varbinary(311) = NULL,
    @lineage_new9 varbinary(311) = NULL,
    @rowguid10 uniqueidentifier = NULL,
    @metadata_type10 tinyint = NULL,
    @generation10 bigint = NULL,
    @lineage_old10 varbinary(311) = NULL,
    @lineage_new10 varbinary(311) = NULL,
    @rowguid11 uniqueidentifier = NULL,
    @metadata_type11 tinyint = NULL,
    @generation11 bigint = NULL,
    @lineage_old11 varbinary(311) = NULL,
    @lineage_new11 varbinary(311) = NULL,
    @rowguid12 uniqueidentifier = NULL,
    @metadata_type12 tinyint = NULL,
    @generation12 bigint = NULL,
    @lineage_old12 varbinary(311) = NULL,
    @lineage_new12 varbinary(311) = NULL,
    @rowguid13 uniqueidentifier = NULL,
    @metadata_type13 tinyint = NULL,
    @generation13 bigint = NULL,
    @lineage_old13 varbinary(311) = NULL,
    @lineage_new13 varbinary(311) = NULL,
    @rowguid14 uniqueidentifier = NULL,
    @metadata_type14 tinyint = NULL,
    @generation14 bigint = NULL,
    @lineage_old14 varbinary(311) = NULL,
    @lineage_new14 varbinary(311) = NULL,
    @rowguid15 uniqueidentifier = NULL,
    @metadata_type15 tinyint = NULL,
    @generation15 bigint = NULL,
    @lineage_old15 varbinary(311) = NULL,
    @lineage_new15 varbinary(311) = NULL,
    @rowguid16 uniqueidentifier = NULL,
    @metadata_type16 tinyint = NULL,
    @generation16 bigint = NULL,
    @lineage_old16 varbinary(311) = NULL,
    @lineage_new16 varbinary(311) = NULL,
    @rowguid17 uniqueidentifier = NULL,
    @metadata_type17 tinyint = NULL,
    @generation17 bigint = NULL,
    @lineage_old17 varbinary(311) = NULL,
    @lineage_new17 varbinary(311) = NULL,
    @rowguid18 uniqueidentifier = NULL,
    @metadata_type18 tinyint = NULL,
    @generation18 bigint = NULL,
    @lineage_old18 varbinary(311) = NULL,
    @lineage_new18 varbinary(311) = NULL,
    @rowguid19 uniqueidentifier = NULL,
    @metadata_type19 tinyint = NULL,
    @generation19 bigint = NULL,
    @lineage_old19 varbinary(311) = NULL,
    @lineage_new19 varbinary(311) = NULL,
    @rowguid20 uniqueidentifier = NULL,
    @metadata_type20 tinyint = NULL,
    @generation20 bigint = NULL,
    @lineage_old20 varbinary(311) = NULL,
    @lineage_new20 varbinary(311) = NULL,
    @rowguid21 uniqueidentifier = NULL,
    @metadata_type21 tinyint = NULL,
    @generation21 bigint = NULL,
    @lineage_old21 varbinary(311) = NULL,
    @lineage_new21 varbinary(311) = NULL,
    @rowguid22 uniqueidentifier = NULL,
    @metadata_type22 tinyint = NULL,
    @generation22 bigint = NULL,
    @lineage_old22 varbinary(311) = NULL,
    @lineage_new22 varbinary(311) = NULL,
    @rowguid23 uniqueidentifier = NULL,
    @metadata_type23 tinyint = NULL,
    @generation23 bigint = NULL,
    @lineage_old23 varbinary(311) = NULL,
    @lineage_new23 varbinary(311) = NULL,
    @rowguid24 uniqueidentifier = NULL,
    @metadata_type24 tinyint = NULL,
    @generation24 bigint = NULL,
    @lineage_old24 varbinary(311) = NULL,
    @lineage_new24 varbinary(311) = NULL,
    @rowguid25 uniqueidentifier = NULL,
    @metadata_type25 tinyint = NULL,
    @generation25 bigint = NULL,
    @lineage_old25 varbinary(311) = NULL,
    @lineage_new25 varbinary(311) = NULL,
    @rowguid26 uniqueidentifier = NULL,
    @metadata_type26 tinyint = NULL,
    @generation26 bigint = NULL,
    @lineage_old26 varbinary(311) = NULL,
    @lineage_new26 varbinary(311) = NULL,
    @rowguid27 uniqueidentifier = NULL,
    @metadata_type27 tinyint = NULL,
    @generation27 bigint = NULL,
    @lineage_old27 varbinary(311) = NULL,
    @lineage_new27 varbinary(311) = NULL,
    @rowguid28 uniqueidentifier = NULL,
    @metadata_type28 tinyint = NULL,
    @generation28 bigint = NULL,
    @lineage_old28 varbinary(311) = NULL,
    @lineage_new28 varbinary(311) = NULL,
    @rowguid29 uniqueidentifier = NULL,
    @metadata_type29 tinyint = NULL,
    @generation29 bigint = NULL,
    @lineage_old29 varbinary(311) = NULL,
    @lineage_new29 varbinary(311) = NULL,
    @rowguid30 uniqueidentifier = NULL,
    @metadata_type30 tinyint = NULL,
    @generation30 bigint = NULL,
    @lineage_old30 varbinary(311) = NULL,
    @lineage_new30 varbinary(311) = NULL,
    @rowguid31 uniqueidentifier = NULL,
    @metadata_type31 tinyint = NULL,
    @generation31 bigint = NULL,
    @lineage_old31 varbinary(311) = NULL,
    @lineage_new31 varbinary(311) = NULL,
    @rowguid32 uniqueidentifier = NULL,
    @metadata_type32 tinyint = NULL,
    @generation32 bigint = NULL,
    @lineage_old32 varbinary(311) = NULL,
    @lineage_new32 varbinary(311) = NULL,
    @rowguid33 uniqueidentifier = NULL,
    @metadata_type33 tinyint = NULL,
    @generation33 bigint = NULL,
    @lineage_old33 varbinary(311) = NULL,
    @lineage_new33 varbinary(311) = NULL,
    @rowguid34 uniqueidentifier = NULL,
    @metadata_type34 tinyint = NULL,
    @generation34 bigint = NULL,
    @lineage_old34 varbinary(311) = NULL,
    @lineage_new34 varbinary(311) = NULL,
    @rowguid35 uniqueidentifier = NULL,
    @metadata_type35 tinyint = NULL,
    @generation35 bigint = NULL,
    @lineage_old35 varbinary(311) = NULL,
    @lineage_new35 varbinary(311) = NULL,
    @rowguid36 uniqueidentifier = NULL,
    @metadata_type36 tinyint = NULL,
    @generation36 bigint = NULL,
    @lineage_old36 varbinary(311) = NULL,
    @lineage_new36 varbinary(311) = NULL,
    @rowguid37 uniqueidentifier = NULL,
    @metadata_type37 tinyint = NULL,
    @generation37 bigint = NULL,
    @lineage_old37 varbinary(311) = NULL,
    @lineage_new37 varbinary(311) = NULL,
    @rowguid38 uniqueidentifier = NULL,
    @metadata_type38 tinyint = NULL,
    @generation38 bigint = NULL,
    @lineage_old38 varbinary(311) = NULL,
    @lineage_new38 varbinary(311) = NULL,
    @rowguid39 uniqueidentifier = NULL,
    @metadata_type39 tinyint = NULL,
    @generation39 bigint = NULL,
    @lineage_old39 varbinary(311) = NULL,
    @lineage_new39 varbinary(311) = NULL,
    @rowguid40 uniqueidentifier = NULL,
    @metadata_type40 tinyint = NULL,
    @generation40 bigint = NULL,
    @lineage_old40 varbinary(311) = NULL,
    @lineage_new40 varbinary(311) = NULL,
    @rowguid41 uniqueidentifier = NULL,
    @metadata_type41 tinyint = NULL,
    @generation41 bigint = NULL,
    @lineage_old41 varbinary(311) = NULL,
    @lineage_new41 varbinary(311) = NULL,
    @rowguid42 uniqueidentifier = NULL,
    @metadata_type42 tinyint = NULL,
    @generation42 bigint = NULL,
    @lineage_old42 varbinary(311) = NULL,
    @lineage_new42 varbinary(311) = NULL,
    @rowguid43 uniqueidentifier = NULL,
    @metadata_type43 tinyint = NULL,
    @generation43 bigint = NULL,
    @lineage_old43 varbinary(311) = NULL,
    @lineage_new43 varbinary(311) = NULL,
    @rowguid44 uniqueidentifier = NULL,
    @metadata_type44 tinyint = NULL,
    @generation44 bigint = NULL,
    @lineage_old44 varbinary(311) = NULL,
    @lineage_new44 varbinary(311) = NULL,
    @rowguid45 uniqueidentifier = NULL,
    @metadata_type45 tinyint = NULL,
    @generation45 bigint = NULL,
    @lineage_old45 varbinary(311) = NULL,
    @lineage_new45 varbinary(311) = NULL,
    @rowguid46 uniqueidentifier = NULL,
    @metadata_type46 tinyint = NULL,
    @generation46 bigint = NULL,
    @lineage_old46 varbinary(311) = NULL,
    @lineage_new46 varbinary(311) = NULL,
    @rowguid47 uniqueidentifier = NULL,
    @metadata_type47 tinyint = NULL,
    @generation47 bigint = NULL,
    @lineage_old47 varbinary(311) = NULL,
    @lineage_new47 varbinary(311) = NULL,
    @rowguid48 uniqueidentifier = NULL,
    @metadata_type48 tinyint = NULL,
    @generation48 bigint = NULL,
    @lineage_old48 varbinary(311) = NULL,
    @lineage_new48 varbinary(311) = NULL,
    @rowguid49 uniqueidentifier = NULL,
    @metadata_type49 tinyint = NULL,
    @generation49 bigint = NULL,
    @lineage_old49 varbinary(311) = NULL,
    @lineage_new49 varbinary(311) = NULL,
    @rowguid50 uniqueidentifier = NULL,
    @metadata_type50 tinyint = NULL,
    @generation50 bigint = NULL,
    @lineage_old50 varbinary(311) = NULL,
    @lineage_new50 varbinary(311) = NULL,
    @rowguid51 uniqueidentifier = NULL,
    @metadata_type51 tinyint = NULL,
    @generation51 bigint = NULL,
    @lineage_old51 varbinary(311) = NULL,
    @lineage_new51 varbinary(311) = NULL,
    @rowguid52 uniqueidentifier = NULL,
    @metadata_type52 tinyint = NULL,
    @generation52 bigint = NULL,
    @lineage_old52 varbinary(311) = NULL,
    @lineage_new52 varbinary(311) = NULL,
    @rowguid53 uniqueidentifier = NULL,
    @metadata_type53 tinyint = NULL,
    @generation53 bigint = NULL,
    @lineage_old53 varbinary(311) = NULL,
    @lineage_new53 varbinary(311) = NULL,
    @rowguid54 uniqueidentifier = NULL,
    @metadata_type54 tinyint = NULL,
    @generation54 bigint = NULL,
    @lineage_old54 varbinary(311) = NULL,
    @lineage_new54 varbinary(311) = NULL,
    @rowguid55 uniqueidentifier = NULL,
    @metadata_type55 tinyint = NULL,
    @generation55 bigint = NULL,
    @lineage_old55 varbinary(311) = NULL,
    @lineage_new55 varbinary(311) = NULL,
    @rowguid56 uniqueidentifier = NULL,
    @metadata_type56 tinyint = NULL,
    @generation56 bigint = NULL,
    @lineage_old56 varbinary(311) = NULL,
    @lineage_new56 varbinary(311) = NULL,
    @rowguid57 uniqueidentifier = NULL,
    @metadata_type57 tinyint = NULL,
    @generation57 bigint = NULL,
    @lineage_old57 varbinary(311) = NULL,
    @lineage_new57 varbinary(311) = NULL,
    @rowguid58 uniqueidentifier = NULL,
    @metadata_type58 tinyint = NULL,
    @generation58 bigint = NULL,
    @lineage_old58 varbinary(311) = NULL,
    @lineage_new58 varbinary(311) = NULL,
    @rowguid59 uniqueidentifier = NULL,
    @metadata_type59 tinyint = NULL,
    @generation59 bigint = NULL,
    @lineage_old59 varbinary(311) = NULL,
    @lineage_new59 varbinary(311) = NULL,
    @rowguid60 uniqueidentifier = NULL,
    @metadata_type60 tinyint = NULL,
    @generation60 bigint = NULL,
    @lineage_old60 varbinary(311) = NULL,
    @lineage_new60 varbinary(311) = NULL,
    @rowguid61 uniqueidentifier = NULL,
    @metadata_type61 tinyint = NULL,
    @generation61 bigint = NULL,
    @lineage_old61 varbinary(311) = NULL,
    @lineage_new61 varbinary(311) = NULL,
    @rowguid62 uniqueidentifier = NULL,
    @metadata_type62 tinyint = NULL,
    @generation62 bigint = NULL,
    @lineage_old62 varbinary(311) = NULL,
    @lineage_new62 varbinary(311) = NULL,
    @rowguid63 uniqueidentifier = NULL,
    @metadata_type63 tinyint = NULL,
    @generation63 bigint = NULL,
    @lineage_old63 varbinary(311) = NULL,
    @lineage_new63 varbinary(311) = NULL,
    @rowguid64 uniqueidentifier = NULL,
    @metadata_type64 tinyint = NULL,
    @generation64 bigint = NULL,
    @lineage_old64 varbinary(311) = NULL,
    @lineage_new64 varbinary(311) = NULL,
    @rowguid65 uniqueidentifier = NULL,
    @metadata_type65 tinyint = NULL,
    @generation65 bigint = NULL,
    @lineage_old65 varbinary(311) = NULL,
    @lineage_new65 varbinary(311) = NULL,
    @rowguid66 uniqueidentifier = NULL,
    @metadata_type66 tinyint = NULL,
    @generation66 bigint = NULL,
    @lineage_old66 varbinary(311) = NULL,
    @lineage_new66 varbinary(311) = NULL,
    @rowguid67 uniqueidentifier = NULL,
    @metadata_type67 tinyint = NULL,
    @generation67 bigint = NULL,
    @lineage_old67 varbinary(311) = NULL,
    @lineage_new67 varbinary(311) = NULL,
    @rowguid68 uniqueidentifier = NULL,
    @metadata_type68 tinyint = NULL,
    @generation68 bigint = NULL,
    @lineage_old68 varbinary(311) = NULL,
    @lineage_new68 varbinary(311) = NULL,
    @rowguid69 uniqueidentifier = NULL,
    @metadata_type69 tinyint = NULL,
    @generation69 bigint = NULL,
    @lineage_old69 varbinary(311) = NULL,
    @lineage_new69 varbinary(311) = NULL,
    @rowguid70 uniqueidentifier = NULL,
    @metadata_type70 tinyint = NULL,
    @generation70 bigint = NULL,
    @lineage_old70 varbinary(311) = NULL,
    @lineage_new70 varbinary(311) = NULL,
    @rowguid71 uniqueidentifier = NULL,
    @metadata_type71 tinyint = NULL,
    @generation71 bigint = NULL,
    @lineage_old71 varbinary(311) = NULL,
    @lineage_new71 varbinary(311) = NULL,
    @rowguid72 uniqueidentifier = NULL,
    @metadata_type72 tinyint = NULL,
    @generation72 bigint = NULL,
    @lineage_old72 varbinary(311) = NULL,
    @lineage_new72 varbinary(311) = NULL,
    @rowguid73 uniqueidentifier = NULL,
    @metadata_type73 tinyint = NULL,
    @generation73 bigint = NULL,
    @lineage_old73 varbinary(311) = NULL,
    @lineage_new73 varbinary(311) = NULL,
    @rowguid74 uniqueidentifier = NULL,
    @metadata_type74 tinyint = NULL,
    @generation74 bigint = NULL,
    @lineage_old74 varbinary(311) = NULL,
    @lineage_new74 varbinary(311) = NULL,
    @rowguid75 uniqueidentifier = NULL,
    @metadata_type75 tinyint = NULL,
    @generation75 bigint = NULL,
    @lineage_old75 varbinary(311) = NULL,
    @lineage_new75 varbinary(311) = NULL,
    @rowguid76 uniqueidentifier = NULL,
    @metadata_type76 tinyint = NULL,
    @generation76 bigint = NULL,
    @lineage_old76 varbinary(311) = NULL,
    @lineage_new76 varbinary(311) = NULL,
    @rowguid77 uniqueidentifier = NULL,
    @metadata_type77 tinyint = NULL,
    @generation77 bigint = NULL,
    @lineage_old77 varbinary(311) = NULL,
    @lineage_new77 varbinary(311) = NULL,
    @rowguid78 uniqueidentifier = NULL,
    @metadata_type78 tinyint = NULL,
    @generation78 bigint = NULL,
    @lineage_old78 varbinary(311) = NULL,
    @lineage_new78 varbinary(311) = NULL,
    @rowguid79 uniqueidentifier = NULL,
    @metadata_type79 tinyint = NULL,
    @generation79 bigint = NULL,
    @lineage_old79 varbinary(311) = NULL,
    @lineage_new79 varbinary(311) = NULL,
    @rowguid80 uniqueidentifier = NULL,
    @metadata_type80 tinyint = NULL,
    @generation80 bigint = NULL,
    @lineage_old80 varbinary(311) = NULL,
    @lineage_new80 varbinary(311) = NULL,
    @rowguid81 uniqueidentifier = NULL,
    @metadata_type81 tinyint = NULL,
    @generation81 bigint = NULL,
    @lineage_old81 varbinary(311) = NULL,
    @lineage_new81 varbinary(311) = NULL,
    @rowguid82 uniqueidentifier = NULL,
    @metadata_type82 tinyint = NULL,
    @generation82 bigint = NULL,
    @lineage_old82 varbinary(311) = NULL,
    @lineage_new82 varbinary(311) = NULL,
    @rowguid83 uniqueidentifier = NULL,
    @metadata_type83 tinyint = NULL,
    @generation83 bigint = NULL,
    @lineage_old83 varbinary(311) = NULL,
    @lineage_new83 varbinary(311) = NULL,
    @rowguid84 uniqueidentifier = NULL,
    @metadata_type84 tinyint = NULL,
    @generation84 bigint = NULL,
    @lineage_old84 varbinary(311) = NULL,
    @lineage_new84 varbinary(311) = NULL,
    @rowguid85 uniqueidentifier = NULL,
    @metadata_type85 tinyint = NULL,
    @generation85 bigint = NULL,
    @lineage_old85 varbinary(311) = NULL,
    @lineage_new85 varbinary(311) = NULL,
    @rowguid86 uniqueidentifier = NULL,
    @metadata_type86 tinyint = NULL,
    @generation86 bigint = NULL,
    @lineage_old86 varbinary(311) = NULL,
    @lineage_new86 varbinary(311) = NULL,
    @rowguid87 uniqueidentifier = NULL,
    @metadata_type87 tinyint = NULL,
    @generation87 bigint = NULL,
    @lineage_old87 varbinary(311) = NULL,
    @lineage_new87 varbinary(311) = NULL,
    @rowguid88 uniqueidentifier = NULL,
    @metadata_type88 tinyint = NULL,
    @generation88 bigint = NULL,
    @lineage_old88 varbinary(311) = NULL,
    @lineage_new88 varbinary(311) = NULL,
    @rowguid89 uniqueidentifier = NULL,
    @metadata_type89 tinyint = NULL,
    @generation89 bigint = NULL,
    @lineage_old89 varbinary(311) = NULL,
    @lineage_new89 varbinary(311) = NULL,
    @rowguid90 uniqueidentifier = NULL,
    @metadata_type90 tinyint = NULL,
    @generation90 bigint = NULL,
    @lineage_old90 varbinary(311) = NULL,
    @lineage_new90 varbinary(311) = NULL,
    @rowguid91 uniqueidentifier = NULL,
    @metadata_type91 tinyint = NULL,
    @generation91 bigint = NULL,
    @lineage_old91 varbinary(311) = NULL,
    @lineage_new91 varbinary(311) = NULL,
    @rowguid92 uniqueidentifier = NULL,
    @metadata_type92 tinyint = NULL,
    @generation92 bigint = NULL,
    @lineage_old92 varbinary(311) = NULL,
    @lineage_new92 varbinary(311) = NULL,
    @rowguid93 uniqueidentifier = NULL,
    @metadata_type93 tinyint = NULL,
    @generation93 bigint = NULL,
    @lineage_old93 varbinary(311) = NULL,
    @lineage_new93 varbinary(311) = NULL,
    @rowguid94 uniqueidentifier = NULL,
    @metadata_type94 tinyint = NULL,
    @generation94 bigint = NULL,
    @lineage_old94 varbinary(311) = NULL,
    @lineage_new94 varbinary(311) = NULL,
    @rowguid95 uniqueidentifier = NULL,
    @metadata_type95 tinyint = NULL,
    @generation95 bigint = NULL,
    @lineage_old95 varbinary(311) = NULL,
    @lineage_new95 varbinary(311) = NULL,
    @rowguid96 uniqueidentifier = NULL,
    @metadata_type96 tinyint = NULL,
    @generation96 bigint = NULL,
    @lineage_old96 varbinary(311) = NULL,
    @lineage_new96 varbinary(311) = NULL,
    @rowguid97 uniqueidentifier = NULL,
    @metadata_type97 tinyint = NULL,
    @generation97 bigint = NULL,
    @lineage_old97 varbinary(311) = NULL,
    @lineage_new97 varbinary(311) = NULL,
    @rowguid98 uniqueidentifier = NULL,
    @metadata_type98 tinyint = NULL,
    @generation98 bigint = NULL,
    @lineage_old98 varbinary(311) = NULL,
    @lineage_new98 varbinary(311) = NULL,
    @rowguid99 uniqueidentifier = NULL,
    @metadata_type99 tinyint = NULL,
    @generation99 bigint = NULL,
    @lineage_old99 varbinary(311) = NULL,
    @lineage_new99 varbinary(311) = NULL,
    @rowguid100 uniqueidentifier = NULL,
    @metadata_type100 tinyint = NULL,
    @generation100 bigint = NULL,
    @lineage_old100 varbinary(311) = NULL,
    @lineage_new100 varbinary(311) = NULL
)
as
    set nocount on
    declare @procname nvarchar(270)
    declare @retcode int

    -- NOTE: this stored procedure returns 0 to indicate failure

    -- security check
    if (1 <> {fn ISPALUSER(@pubid)})
    begin
        RAISERROR (14126, 11, -1)
        return 0
    end

    if @check_permission = 1
    begin
        declare @objid int
        declare @permissions int

        select @objid=objid, @permissions=check_permissions from dbo.sysmergearticles
            where nickname=@tablenick and (pubid is NULL or pubid=@pubid)
        if @objid is NULL
            return (0)

        exec @retcode = sys.sp_MSreplcheck_permission @objid = @objid, @type = 3, @permissions = @permissions
        if @retcode<>0 or @@ERROR<>0
            return (4)
    end

    select @procname= 'dbo.' + delete_proc from dbo.sysmergearticles where nickname = @tablenick and pubid=@pubid

    select @retcode = 1
    exec @retcode = @procname
                        @rows_tobe_deleted,
                        @partition_id,
                        @rowguid1,
                        @metadata_type1,
                        @generation1,
                        @lineage_old1,
                        @lineage_new1,
                        @rowguid2,
                        @metadata_type2,
                        @generation2,
                        @lineage_old2,
                        @lineage_new2,
                        @rowguid3,
                        @metadata_type3,
                        @generation3,
                        @lineage_old3,
                        @lineage_new3,
                        @rowguid4,
                        @metadata_type4,
                        @generation4,
                        @lineage_old4,
                        @lineage_new4,
                        @rowguid5,
                        @metadata_type5,
                        @generation5,
                        @lineage_old5,
                        @lineage_new5,
                        @rowguid6,
                        @metadata_type6,
                        @generation6,
                        @lineage_old6,
                        @lineage_new6,
                        @rowguid7,
                        @metadata_type7,
                        @generation7,
                        @lineage_old7,
                        @lineage_new7,
                        @rowguid8,
                        @metadata_type8,
                        @generation8,
                        @lineage_old8,
                        @lineage_new8,
                        @rowguid9,
                        @metadata_type9,
                        @generation9,
                        @lineage_old9,
                        @lineage_new9,
                        @rowguid10,
                        @metadata_type10,
                        @generation10,
                        @lineage_old10,
                        @lineage_new10,
                        @rowguid11,
                        @metadata_type11,
                        @generation11,
                        @lineage_old11,
                        @lineage_new11,
                        @rowguid12,
                        @metadata_type12,
                        @generation12,
                        @lineage_old12,
                        @lineage_new12,
                        @rowguid13,
                        @metadata_type13,
                        @generation13,
                        @lineage_old13,
                        @lineage_new13,
                        @rowguid14,
                        @metadata_type14,
                        @generation14,
                        @lineage_old14,
                        @lineage_new14,
     @rowguid15,
                        @metadata_type15,
                        @generation15,
                        @lineage_old15,
                        @lineage_new15,
                        @rowguid16,
                        @metadata_type16,
                        @generation16,
                        @lineage_old16,
                        @lineage_new16,
                        @rowguid17,
                        @metadata_type17,
                        @generation17,
                        @lineage_old17,
                        @lineage_new17,
                        @rowguid18,
                        @metadata_type18,
                        @generation18,
                        @lineage_old18,
                        @lineage_new18,
                        @rowguid19,
                        @metadata_type19,
                        @generation19,
                        @lineage_old19,
                        @lineage_new19,
                        @rowguid20,
                        @metadata_type20,
                        @generation20,
                        @lineage_old20,
                        @lineage_new20,
                        @rowguid21,
                        @metadata_type21,
                        @generation21,
                        @lineage_old21,
                        @lineage_new21,
                        @rowguid22,
                        @metadata_type22,
                        @generation22,
                        @lineage_old22,
                        @lineage_new22,
                        @rowguid23,
                        @metadata_type23,
                        @generation23,
                        @lineage_old23,
                        @lineage_new23,
                        @rowguid24,
                        @metadata_type24,
                        @generation24,
                        @lineage_old24,
                        @lineage_new24,
                        @rowguid25,
                        @metadata_type25,
                        @generation25,
                        @lineage_old25,
                        @lineage_new25,
                        @rowguid26,
                        @metadata_type26,
                        @generation26,
                        @lineage_old26,
                        @lineage_new26,
                        @rowguid27,
                        @metadata_type27,
                        @generation27,
                        @lineage_old27,
                        @lineage_new27,
                        @rowguid28,
                        @metadata_type28,
                        @generation28,
                        @lineage_old28,
                        @lineage_new28,
                        @rowguid29,
                        @metadata_type29,
                        @generation29,
                        @lineage_old29,
                        @lineage_new29,
                        @rowguid30,
                        @metadata_type30,
                        @generation30,
                        @lineage_old30,
                        @lineage_new30,
                        @rowguid31,
                        @metadata_type31,
                        @generation31,
                        @lineage_old31,
                        @lineage_new31,
                        @rowguid32,
                        @metadata_type32,
                        @generation32,
                        @lineage_old32,
                        @lineage_new32,
                        @rowguid33,
                        @metadata_type33,
                        @generation33,
                        @lineage_old33,
                        @lineage_new33,
                        @rowguid34,
                        @metadata_type34,
                        @generation34,
                        @lineage_old34,
                        @lineage_new34,
                        @rowguid35,
                        @metadata_type35,
                        @generation35,
                        @lineage_old35,
                        @lineage_new35,
                        @rowguid36,
                        @metadata_type36,
                        @generation36,
                        @lineage_old36,
                        @lineage_new36,
                        @rowguid37,
                        @metadata_type37,
                        @generation37,
                        @lineage_old37,
                        @lineage_new37,
                        @rowguid38,
                        @metadata_type38,
                        @generation38,
                        @lineage_old38,
                        @lineage_new38,
                        @rowguid39,
                        @metadata_type39,
                        @generation39,
                        @lineage_old39,
                        @lineage_new39,
                        @rowguid40,
                        @metadata_type40,
                        @generation40,
                        @lineage_old40,
                        @lineage_new40,
                        @rowguid41,
                        @metadata_type41,
                        @generation41,
                        @lineage_old41,
                        @lineage_new41,
                        @rowguid42,
                        @metadata_type42,
                        @generation42,
                        @lineage_old42,
                        @lineage_new42,
                        @rowguid43,
                        @metadata_type43,
                        @generation43,
                        @lineage_old43,
                        @lineage_new43,
                        @rowguid44,
                        @metadata_type44,
                        @generation44,
                        @lineage_old44,
                        @lineage_new44,
                        @rowguid45,
                        @metadata_type45,
                        @generation45,
                        @lineage_old45,
                        @lineage_new45,
                        @rowguid46,
                        @metadata_type46,
                        @generation46,
                        @lineage_old46,
                        @lineage_new46,
                        @rowguid47,
                        @metadata_type47,
                        @generation47,
                        @lineage_old47,
                        @lineage_new47,
                        @rowguid48,
                        @metadata_type48,
                        @generation48,
                        @lineage_old48,
                        @lineage_new48,
                        @rowguid49,
                        @metadata_type49,
                        @generation49,
                        @lineage_old49,
                        @lineage_new49,
                        @rowguid50,
                        @metadata_type50,
                        @generation50,
                        @lineage_old50,
                        @lineage_new50,
                        @rowguid51,
                        @metadata_type51,
                        @generation51,
                        @lineage_old51,
                        @lineage_new51,
                        @rowguid52,
                        @metadata_type52,
                        @generation52,
                        @lineage_old52,
                        @lineage_new52,
                        @rowguid53,
                        @metadata_type53,
                        @generation53,
                        @lineage_old53,
                        @lineage_new53,
                        @rowguid54,
                        @metadata_type54,
   @generation54,
                        @lineage_old54,
                        @lineage_new54,
                        @rowguid55,
                        @metadata_type55,
                        @generation55,
                        @lineage_old55,
                        @lineage_new55,
                        @rowguid56,
                        @metadata_type56,
                        @generation56,
                        @lineage_old56,
                        @lineage_new56,
                        @rowguid57,
                        @metadata_type57,
                        @generation57,
                        @lineage_old57,
                        @lineage_new57,
                        @rowguid58,
                        @metadata_type58,
                        @generation58,
                        @lineage_old58,
                        @lineage_new58,
                        @rowguid59,
                        @metadata_type59,
                        @generation59,
                        @lineage_old59,
                        @lineage_new59,
                        @rowguid60,
                        @metadata_type60,
                        @generation60,
                        @lineage_old60,
                        @lineage_new60,
                        @rowguid61,
                        @metadata_type61,
                        @generation61,
                        @lineage_old61,
                        @lineage_new61,
                        @rowguid62,
                        @metadata_type62,
                        @generation62,
                        @lineage_old62,
                        @lineage_new62,
                        @rowguid63,
                        @metadata_type63,
                        @generation63,
                        @lineage_old63,
                        @lineage_new63,
                        @rowguid64,
                        @metadata_type64,
                        @generation64,
                        @lineage_old64,
                        @lineage_new64,
                        @rowguid65,
                        @metadata_type65,
                        @generation65,
                        @lineage_old65,
                        @lineage_new65,
                        @rowguid66,
                        @metadata_type66,
                        @generation66,
                        @lineage_old66,
                        @lineage_new66,
                        @rowguid67,
                        @metadata_type67,
                        @generation67,
                        @lineage_old67,
                        @lineage_new67,
                        @rowguid68,
                        @metadata_type68,
                        @generation68,
                        @lineage_old68,
                        @lineage_new68,
                        @rowguid69,
                        @metadata_type69,
                        @generation69,
                        @lineage_old69,
                        @lineage_new69,
                        @rowguid70,
                        @metadata_type70,
                        @generation70,
                        @lineage_old70,
                        @lineage_new70,
                        @rowguid71,
                        @metadata_type71,
                        @generation71,
                        @lineage_old71,
                        @lineage_new71,
                        @rowguid72,
                        @metadata_type72,
                        @generation72,
                        @lineage_old72,
                        @lineage_new72,
                        @rowguid73,
                        @metadata_type73,
                        @generation73,
                        @lineage_old73,
                        @lineage_new73,
                        @rowguid74,
                   @metadata_type74,
                        @generation74,
                        @lineage_old74,
                        @lineage_new74,
                        @rowguid75,
                        @metadata_type75,
                        @generation75,
                        @lineage_old75,
                        @lineage_new75,
                        @rowguid76,
                        @metadata_type76,
                        @generation76,
                        @lineage_old76,
                        @lineage_new76,
                        @rowguid77,
                        @metadata_type77,
                        @generation77,
                        @lineage_old77,
                        @lineage_new77,
                        @rowguid78,
                        @metadata_type78,
                        @generation78,
                        @lineage_old78,
                        @lineage_new78,
                        @rowguid79,
                        @metadata_type79,
                        @generation79,
                        @lineage_old79,
                        @lineage_new79,
                        @rowguid80,
                        @metadata_type80,
                        @generation80,
                        @lineage_old80,
                        @lineage_new80,
                        @rowguid81,
                        @metadata_type81,
                        @generation81,
                        @lineage_old81,
                        @lineage_new81,
                        @rowguid82,
                        @metadata_type82,
                        @generation82,
                        @lineage_old82,
                        @lineage_new82,
                        @rowguid83,
                        @metadata_type83,
                        @generation83,
                        @lineage_old83,
                        @lineage_new83,
                        @rowguid84,
                        @metadata_type84,
                        @generation84,
                        @lineage_old84,
                        @lineage_new84,
                        @rowguid85,
                        @metadata_type85,
                        @generation85,
                        @lineage_old85,
                        @lineage_new85,
                        @rowguid86,
                        @metadata_type86,
                        @generation86,
                        @lineage_old86,
                        @lineage_new86,
                        @rowguid87,
                        @metadata_type87,
                        @generation87,
                        @lineage_old87,
                        @lineage_new87,
                        @rowguid88,
                        @metadata_type88,
                        @generation88,
                        @lineage_old88,
                        @lineage_new88,
                        @rowguid89,
                        @metadata_type89,
                        @generation89,
                        @lineage_old89,
                        @lineage_new89,
                        @rowguid90,
                        @metadata_type90,
                        @generation90,
                        @lineage_old90,
                        @lineage_new90,
                        @rowguid91,
                        @metadata_type91,
                        @generation91,
                        @lineage_old91,
                        @lineage_new91,
                        @rowguid92,
                        @metadata_type92,
                        @generation92,
                        @lineage_old92,
                        @lineage_new92,
                        @rowguid93,
                        @metadata_type93,
                        @generation93,
                        @lineage_old93,
 @lineage_new93,
                        @rowguid94,
                        @metadata_type94,
                        @generation94,
                        @lineage_old94,
                        @lineage_new94,
                        @rowguid95,
                        @metadata_type95,
                        @generation95,
                        @lineage_old95,
                        @lineage_new95,
                        @rowguid96,
                        @metadata_type96,
                        @generation96,
                        @lineage_old96,
                        @lineage_new96,
                        @rowguid97,
                        @metadata_type97,
                        @generation97,
                        @lineage_old97,
                        @lineage_new97,
                        @rowguid98,
                        @metadata_type98,
                        @generation98,
                        @lineage_old98,
                        @lineage_new98,
                        @rowguid99,
                        @metadata_type99,
                        @generation99,
                        @lineage_old99,
                        @lineage_new99,
                        @rowguid100,
                        @metadata_type100,
                        @generation100,
                        @lineage_old100,
                        @lineage_new100

    if @@error<>0 and @retcode=1
        return 0

    return @retcode

 
Last revision 2008RTM
See also

  sp_MSdelrowsbatch_downloadonly (Procedure)
sp_MSdrop_rlrecon (Procedure)
       



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