May 15, 2012

sp_MSgetonerowlightweight (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_MSgetonerowlightweight(int @tablenick
, uniqueidentifier @rowguid
, uniqueidentifier @pubid)

MetaData:

 create procedure sys.sp_MSgetonerowlightweight  
@tablenick int,
@rowguid uniqueidentifier,
@pubid uniqueidentifier
as
declare @retcode smallint
declare @procname sysname
declare @postfix nchar(32)

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

select @postfix= procname_postfix
from dbo.sysmergearticles
where nickname = @tablenick and pubid = @pubid

set @procname= quotename('MSmerge_lws_sp_multi_' + @postfix)

exec @retcode= @procname @action = 1, @rowguid = @rowguid
if @@error<>0 or @retcode<>0 return (1)

return (0)

No comments:

Post a Comment

Total Pageviews