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