May 21, 2012

sp_MSinitdynamicsubscriber (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_MSinitdynamicsubscriber(int @maxrows
, int @tablenick
, uniqueidentifier @rowguid
, uniqueidentifier @pubid
, int @compatlevel
, bit @enumentirerowmetadata
, bit @blob_cols_at_the_end)

MetaData:

   
create procedure sys.sp_MSinitdynamicsubscriber
(@maxrows int,
@tablenick int,
@rowguid uniqueidentifier,
@pubid uniqueidentifier = NULL,
@compatlevel int = 10, -- backward compatibility level, default=Sphinx
@enumentirerowmetadata bit= 1,
@blob_cols_at_the_end bit = 0)
as
declare @retcode smallint
declare @procname nvarchar(290)

-- Security Checking
-- PAL user access
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @pubid = @pubid, @tablenick = @tablenick
if (@retcode <> 0) or (@@error <> 0)
return 1


if (@tablenick is null)
begin
RAISERROR(14043, 16, -1, '@tablenick', 'sp_MSinitdynamicsubscriber')
return (1)
end
select @procname = view_sel_proc from dbo.sysmergearticles where
pubid = @pubid and nickname = @tablenick

exec @retcode= @procname
@tablenick= @tablenick,
@max_rows= @maxrows,
@guidlast= @rowguid,
@compatlevel= @compatlevel,
@pubid= @pubid,
@enumentirerowmetadata= @enumentirerowmetadata,
@blob_cols_at_the_end = @blob_cols_at_the_end

if @@ERROR<>0 or @retcode<>0
begin
return (1)
end
return (0)

No comments:

Post a Comment

Total Pageviews