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_MSget_latest_peerlsn(nvarchar @originator_publication, nvarchar @originator
, nvarchar @originator_db)
MetaData:
create procedure sys.sp_MSget_latest_peerlsn ( @originator_publication sysname, @originator sysname, @originator_db sysname, @xact_seqno binary(10) output ) as begin declare @retcode int -- -- Security check -- exec @retcode = sp_MSreplcheck_subscribe if @@error != 0 or @retcode != 0 return 1 select @xact_seqno = originator_lsn from MSpeer_lsns with (NOLOCK) where originator = UPPER(@originator) and originator_db = @originator_db and originator_publication = @originator_publication if @@error <> 0 return(1) return 0 end
No comments:
Post a Comment