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_MSdeletemetadataactionrequest(uniqueidentifier @pubid, int @tablenick
, uniqueidentifier @rowguid1
, uniqueidentifier @rowguid2
, uniqueidentifier @rowguid3
, uniqueidentifier @rowguid4
, uniqueidentifier @rowguid5
, uniqueidentifier @rowguid6
, uniqueidentifier @rowguid7
, uniqueidentifier @rowguid8
, uniqueidentifier @rowguid9
, uniqueidentifier @rowguid10
, uniqueidentifier @rowguid11
, uniqueidentifier @rowguid12
, uniqueidentifier @rowguid13
, uniqueidentifier @rowguid14
, uniqueidentifier @rowguid15
, uniqueidentifier @rowguid16
, uniqueidentifier @rowguid17
, uniqueidentifier @rowguid18
, uniqueidentifier @rowguid19
, uniqueidentifier @rowguid20
, uniqueidentifier @rowguid21
, uniqueidentifier @rowguid22
, uniqueidentifier @rowguid23
, uniqueidentifier @rowguid24
, uniqueidentifier @rowguid25
, uniqueidentifier @rowguid26
, uniqueidentifier @rowguid27
, uniqueidentifier @rowguid28
, uniqueidentifier @rowguid29
, uniqueidentifier @rowguid30
, uniqueidentifier @rowguid31
, uniqueidentifier @rowguid32
, uniqueidentifier @rowguid33
, uniqueidentifier @rowguid34
, uniqueidentifier @rowguid35
, uniqueidentifier @rowguid36
, uniqueidentifier @rowguid37
, uniqueidentifier @rowguid38
, uniqueidentifier @rowguid39
, uniqueidentifier @rowguid40
, uniqueidentifier @rowguid41
, uniqueidentifier @rowguid42
, uniqueidentifier @rowguid43
, uniqueidentifier @rowguid44
, uniqueidentifier @rowguid45
, uniqueidentifier @rowguid46
, uniqueidentifier @rowguid47
, uniqueidentifier @rowguid48
, uniqueidentifier @rowguid49
, uniqueidentifier @rowguid50
, uniqueidentifier @rowguid51
, uniqueidentifier @rowguid52
, uniqueidentifier @rowguid53
, uniqueidentifier @rowguid54
, uniqueidentifier @rowguid55
, uniqueidentifier @rowguid56
, uniqueidentifier @rowguid57
, uniqueidentifier @rowguid58
, uniqueidentifier @rowguid59
, uniqueidentifier @rowguid60
, uniqueidentifier @rowguid61
, uniqueidentifier @rowguid62
, uniqueidentifier @rowguid63
, uniqueidentifier @rowguid64
, uniqueidentifier @rowguid65
, uniqueidentifier @rowguid66
, uniqueidentifier @rowguid67
, uniqueidentifier @rowguid68
, uniqueidentifier @rowguid69
, uniqueidentifier @rowguid70
, uniqueidentifier @rowguid71
, uniqueidentifier @rowguid72
, uniqueidentifier @rowguid73
, uniqueidentifier @rowguid74
, uniqueidentifier @rowguid75
, uniqueidentifier @rowguid76
, uniqueidentifier @rowguid77
, uniqueidentifier @rowguid78
, uniqueidentifier @rowguid79
, uniqueidentifier @rowguid80
, uniqueidentifier @rowguid81
, uniqueidentifier @rowguid82
, uniqueidentifier @rowguid83
, uniqueidentifier @rowguid84
, uniqueidentifier @rowguid85
, uniqueidentifier @rowguid86
, uniqueidentifier @rowguid87
, uniqueidentifier @rowguid88
, uniqueidentifier @rowguid89
, uniqueidentifier @rowguid90
, uniqueidentifier @rowguid91
, uniqueidentifier @rowguid92
, uniqueidentifier @rowguid93
, uniqueidentifier @rowguid94
, uniqueidentifier @rowguid95
, uniqueidentifier @rowguid96
, uniqueidentifier @rowguid97
, uniqueidentifier @rowguid98
, uniqueidentifier @rowguid99
, uniqueidentifier @rowguid100)
MetaData:
create procedure sys.sp_MSdeletemetadataactionrequest ( @pubid uniqueidentifier, @tablenick int, @rowguid1 uniqueidentifier, @rowguid2 uniqueidentifier = NULL, @rowguid3 uniqueidentifier = NULL, @rowguid4 uniqueidentifier = NULL, @rowguid5 uniqueidentifier = NULL, @rowguid6 uniqueidentifier = NULL, @rowguid7 uniqueidentifier = NULL, @rowguid8 uniqueidentifier = NULL, @rowguid9 uniqueidentifier = NULL, @rowguid10 uniqueidentifier = NULL, @rowguid11 uniqueidentifier = NULL, @rowguid12 uniqueidentifier = NULL, @rowguid13 uniqueidentifier = NULL, @rowguid14 uniqueidentifier = NULL, @rowguid15 uniqueidentifier = NULL, @rowguid16 uniqueidentifier = NULL, @rowguid17 uniqueidentifier = NULL, @rowguid18 uniqueidentifier = NULL, @rowguid19 uniqueidentifier = NULL, @rowguid20 uniqueidentifier = NULL, @rowguid21 uniqueidentifier = NULL, @rowguid22 uniqueidentifier = NULL, @rowguid23 uniqueidentifier = NULL, @rowguid24 uniqueidentifier = NULL, @rowguid25 uniqueidentifier = NULL, @rowguid26 uniqueidentifier = NULL, @rowguid27 uniqueidentifier = NULL, @rowguid28 uniqueidentifier = NULL, @rowguid29 uniqueidentifier = NULL, @rowguid30 uniqueidentifier = NULL, @rowguid31 uniqueidentifier = NULL, @rowguid32 uniqueidentifier = NULL, @rowguid33 uniqueidentifier = NULL, @rowguid34 uniqueidentifier = NULL, @rowguid35 uniqueidentifier = NULL, @rowguid36 uniqueidentifier = NULL, @rowguid37 uniqueidentifier = NULL, @rowguid38 uniqueidentifier = NULL, @rowguid39 uniqueidentifier = NULL, @rowguid40 uniqueidentifier = NULL, @rowguid41 uniqueidentifier = NULL, @rowguid42 uniqueidentifier = NULL, @rowguid43 uniqueidentifier = NULL, @rowguid44 uniqueidentifier = NULL, @rowguid45 uniqueidentifier = NULL, @rowguid46 uniqueidentifier = NULL, @rowguid47 uniqueidentifier = NULL, @rowguid48 uniqueidentifier = NULL, @rowguid49 uniqueidentifier = NULL, @rowguid50 uniqueidentifier = NULL, @rowguid51 uniqueidentifier = NULL, @rowguid52 uniqueidentifier = NULL, @rowguid53 uniqueidentifier = NULL, @rowguid54 uniqueidentifier = NULL, @rowguid55 uniqueidentifier = NULL, @rowguid56 uniqueidentifier = NULL, @rowguid57 uniqueidentifier = NULL, @rowguid58 uniqueidentifier = NULL, @rowguid59 uniqueidentifier = NULL, @rowguid60 uniqueidentifier = NULL, @rowguid61 uniqueidentifier = NULL, @rowguid62 uniqueidentifier = NULL, @rowguid63 uniqueidentifier = NULL, @rowguid64 uniqueidentifier = NULL, @rowguid65 uniqueidentifier = NULL, @rowguid66 uniqueidentifier = NULL, @rowguid67 uniqueidentifier = NULL, @rowguid68 uniqueidentifier = NULL, @rowguid69 uniqueidentifier = NULL, @rowguid70 uniqueidentifier = NULL, @rowguid71 uniqueidentifier = NULL, @rowguid72 uniqueidentifier = NULL, @rowguid73 uniqueidentifier = NULL, @rowguid74 uniqueidentifier = NULL, @rowguid75 uniqueidentifier = NULL, @rowguid76 uniqueidentifier = NULL, @rowguid77 uniqueidentifier = NULL, @rowguid78 uniqueidentifier = NULL, @rowguid79 uniqueidentifier = NULL, @rowguid80 uniqueidentifier = NULL, @rowguid81 uniqueidentifier = NULL, @rowguid82 uniqueidentifier = NULL, @rowguid83 uniqueidentifier = NULL, @rowguid84 uniqueidentifier = NULL, @rowguid85 uniqueidentifier = NULL, @rowguid86 uniqueidentifier = NULL, @rowguid87 uniqueidentifier = NULL, @rowguid88 uniqueidentifier = NULL, @rowguid89 uniqueidentifier = NULL, @rowguid90 uniqueidentifier = NULL, @rowguid91 uniqueidentifier = NULL, @rowguid92 uniqueidentifier = NULL, @rowguid93 uniqueidentifier = NULL, @rowguid94 uniqueidentifier = NULL, @rowguid95 uniqueidentifier = NULL, @rowguid96 uniqueidentifier = NULL, @rowguid97 uniqueidentifier = NULL, @rowguid98 uniqueidentifier = NULL, @rowguid99 uniqueidentifier = NULL, @rowguid100 uniqueidentifier = NULL ) as if {fn ISPALUSER(@pubid)} <> 1 begin raiserror(14260, 16, -1) return (1) end delete dbo.MSmerge_metadataaction_request with (rowlock) from ( select @rowguid1 as rowguid union all select @rowguid2 as rowguid union all select @rowguid3 as rowguid union all select @rowguid4 as rowguid union all select @rowguid5 as rowguid union all select @rowguid6 as rowguid union all select @rowguid7 as rowguid union all select @rowguid8 as rowguid union all select @rowguid9 as rowguid union all select @rowguid10 as rowguid union all select @rowguid11 as rowguid union all select @rowguid12 as rowguid union all select @rowguid13 as rowguid union all select @rowguid14 as rowguid union all select @rowguid15 as rowguid union all select @rowguid16 as rowguid union all select @rowguid17 as rowguid union all select @rowguid18 as rowguid union all select @rowguid19 as rowguid union all select @rowguid20 as rowguid union all select @rowguid21 as rowguid union all select @rowguid22 as rowguid union all select @rowguid23 as rowguid union all select @rowguid24 as rowguid union all select @rowguid25 as rowguid union all select @rowguid26 as rowguid union all select @rowguid27 as rowguid union all select @rowguid28 as rowguid union all select @rowguid29 as rowguid union all select @rowguid30 as rowguid union all select @rowguid31 as rowguid union all select @rowguid32 as rowguid union all select @rowguid33 as rowguid union all select @rowguid34 as rowguid union all select @rowguid35 as rowguid union all select @rowguid36 as rowguid union all select @rowguid37 as rowguid union all select @rowguid38 as rowguid union all select @rowguid39 as rowguid union all select @rowguid40 as rowguid union all select @rowguid41 as rowguid union all select @rowguid42 as rowguid union all select @rowguid43 as rowguid union all select @rowguid44 as rowguid union all select @rowguid45 as rowguid union all select @rowguid46 as rowguid union all select @rowguid47 as rowguid union all select @rowguid48 as rowguid union all select @rowguid49 as rowguid union all select @rowguid50 as rowguid union all select @rowguid51 as rowguid union all select @rowguid52 as rowguid union all select @rowguid53 as rowguid union all select @rowguid54 as rowguid union all select @rowguid55 as rowguid union all select @rowguid56 as rowguid union all select @rowguid57 as rowguid union all select @rowguid58 as rowguid union all select @rowguid59 as rowguid union all select @rowguid60 as rowguid union all select @rowguid61 as rowguid union all select @rowguid62 as rowguid union all select @rowguid63 as rowguid union all select @rowguid64 as rowguid union all select @rowguid65 as rowguid union all select @rowguid66 as rowguid union all select @rowguid67 as rowguid union all select @rowguid68 as rowguid union all select @rowguid69 as rowguid union all select @rowguid70 as rowguid union all select @rowguid71 as rowguid union all select @rowguid72 as rowguid union all select @rowguid73 as rowguid union all select @rowguid74 as rowguid union all select @rowguid75 as rowguid union all select @rowguid76 as rowguid union all select @rowguid77 as rowguid union all select @rowguid78 as rowguid union all select @rowguid79 as rowguid union all select @rowguid80 as rowguid union all select @rowguid81 as rowguid union all select @rowguid82 as rowguid union all select @rowguid83 as rowguid union all select @rowguid84 as rowguid union all select @rowguid85 as rowguid union all select @rowguid86 as rowguid union all select @rowguid87 as rowguid union all select @rowguid88 as rowguid union all select @rowguid89 as rowguid union all select @rowguid90 as rowguid union all select @rowguid91 as rowguid union all select @rowguid92 as rowguid union all select @rowguid93 as rowguid union all select @rowguid94 as rowguid union all select @rowguid95 as rowguid union all select @rowguid96 as rowguid union all select @rowguid97 as rowguid union all select @rowguid98 as rowguid union all select @rowguid99 as rowguid union all select @rowguid100 as rowguid ) as rows inner join dbo.MSmerge_metadataaction_request m with (rowlock) on m.rowguid = rows.rowguid and m.tablenick = @tablenick and rows.rowguid is not NULL option (force order, loop join) if @@error<>0 return 1
No comments:
Post a Comment