May 15, 2012

sp_MSgetmetadatabatch90new (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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_MSgetmetadatabatch90new(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_MSgetmetadatabatch90new  
(@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
declare @procname nvarchar(270)
declare @retcode int

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

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

exec @retcode = @procname
@rowguid1,
@rowguid2,
@rowguid3,
@rowguid4,
@rowguid5,
@rowguid6,
@rowguid7,
@rowguid8,
@rowguid9,
@rowguid10,
@rowguid11,
@rowguid12,
@rowguid13,
@rowguid14,
@rowguid15,
@rowguid16,
@rowguid17,
@rowguid18,
@rowguid19,
@rowguid20,
@rowguid21,
@rowguid22,
@rowguid23,
@rowguid24,
@rowguid25,
@rowguid26,
@rowguid27,
@rowguid28,
@rowguid29,
@rowguid30,
@rowguid31,
@rowguid32,
@rowguid33,
@rowguid34,
@rowguid35,
@rowguid36,
@rowguid37,
@rowguid38,
@rowguid39,
@rowguid40,
@rowguid41,
@rowguid42,
@rowguid43,
@rowguid44,
@rowguid45,
@rowguid46,
@rowguid47,
@rowguid48,
@rowguid49,
@rowguid50,
@rowguid51,
@rowguid52,
@rowguid53,
@rowguid54,
@rowguid55,
@rowguid56,
@rowguid57,
@rowguid58,
@rowguid59,
@rowguid60,
@rowguid61,
@rowguid62,
@rowguid63,
@rowguid64,
@rowguid65,
@rowguid66,
@rowguid67,
@rowguid68,
@rowguid69,
@rowguid70,
@rowguid71,
@rowguid72,
@rowguid73,
@rowguid74,
@rowguid75,
@rowguid76,
@rowguid77,
@rowguid78,
@rowguid79,
@rowguid80,
@rowguid81,
@rowguid82,
@rowguid83,
@rowguid84,
@rowguid85,
@rowguid86,
@rowguid87,
@rowguid88,
@rowguid89,
@rowguid90,
@rowguid91,
@rowguid92,
@rowguid93,
@rowguid94,
@rowguid95,
@rowguid96,
@rowguid97,
@rowguid98,
@rowguid99,
@rowguid100

if @@error <>0 or @retcode <> 0
begin
raiserror(20680, 16, -1)
return (1)
end

return 0

No comments:

Post a Comment

Total Pageviews