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_MSgetalternaterecgens(uniqueidentifier @repid)MetaData:
-- retrieve recgen information about all alternate publications known at this replica create procedure sys.sp_MSgetalternaterecgens @repid uniqueidentifier as declare @retcode int declare @publisher sysname declare @publisher_db sysname declare @publication sysname -- -- do permission checking -- exec @retcode = sys.sp_MSrepl_PAL_rolecheck @repid = @repid if @retcode<>0 or @@ERROR<>0 return (1) select @publisher= publisher, @publisher_db= publisher_db, @publication= name from dbo.sysmergepublications where pubid = @repid select distinct p.pubid as altpubid, s.recguid as recguid, s.recgen as recgen from dbo.sysmergesubscriptions s, dbo.sysmergepublications p, dbo.MSmerge_altsyncpartners alt where (p.pubid = alt.subid or p.pubid = alt.alternate_subid) and p.pubid <> @repid and upper(s.subscriber_server collate SQL_Latin1_General_CP1_CS_AS) = upper(p.publisher collate SQL_Latin1_General_CP1_CS_AS) and s.db_name = p.publisher_db and s.pubid = @repid and s.recguid is not null and s.recgen is not null return @retcode
No comments:
Post a Comment