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_MSCleanupForPullReinit(nvarchar @publication, nvarchar @publisher_db
, nvarchar @publisher)
MetaData:
create procedure sys.sp_MSCleanupForPullReinit ( @publication sysname, @publisher_db sysname, @publisher sysname = NULL ) AS declare @pubid uniqueidentifier declare @artid uniqueidentifier declare @retcode smallint -- -- Security Check -- EXEC @retcode = sys.sp_MSreplcheck_publish IF @@ERROR <> 0 or @retcode <> 0 return (1) if @publisher is NULL set @publisher = publishingservername() -- This only gets called after database is enable to subscribe, so -- sysmergepublications should exist select @pubid = pubid from dbo.sysmergepublications where name = @publication and publisher_db = @publisher_db and upper(publisher collate SQL_Latin1_General_CP1_CS_AS) = upper(@publisher collate SQL_Latin1_General_CP1_CS_AS) and status <> 7 -- REPLICA_STATUS_BeforeRestore -- Normal case - nothing to cleanup, just return -- if @pubid is null return (1) select @retcode = 0 exec @retcode = sys.sp_MSCleanupForPullReinitWithPubId @pubid = @pubid return @retcode
No comments:
Post a Comment