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_MSmarkreinit(nvarchar @publisher, nvarchar @publisher_db
, nvarchar @publication
, nvarchar @subscriber
, nvarchar @subscriber_db
, int @reset_reinit)
MetaData:
CREATE PROCEDURE sys.sp_MSmarkreinit ( @publisher sysname, @publisher_db sysname, @publication sysname, @subscriber sysname, @subscriber_db sysname, @reset_reinit int ) AS begin set nocount on -- This proc is used to mark the status in MSmerge_subscriptions and this status -- is used to prevent expiry of <= 80 subscribers when they are marked for reinit -- This proc is a security threat becuase any user with PAL access can set this staus -- and influence the expiry of any arbitrary subscriber. Therefore, this proc is a no-op -- in 90 and 80 & less subscribers who are marked for reinit will be expired as usual end
No comments:
Post a Comment