May 11, 2012

sp_MSenum_metadataaction_requests (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_MSenum_metadataaction_requests(int @tablenick_last
, uniqueidentifier @rowguid_last
, uniqueidentifier @pubid
, int @max_rows)

MetaData:

 create procedure sys.sp_MSenum_metadataaction_requests  
@tablenick_last int,
@rowguid_last uniqueidentifier,
@pubid uniqueidentifier,
@max_rows int
as
set nocount on
declare @retcode int

-- Security check
exec @retcode= sys.sp_MSreplcheck_subscribe
if @retcode<>0 or @@error<>0 return 1

select top (@max_rows) tablenick, rowguid, action
from dbo.MSmerge_metadataaction_request
where (tablenick=@tablenick_last and rowguid>@rowguid_last)
or
(tablenick>@tablenick_last)
order by tablenick asc, rowguid asc

if @@error<>0
return 1
else
return 0

No comments:

Post a Comment

Total Pageviews