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_MSpeersendresponse(int @request_id, nvarchar @originator
, nvarchar @originator_db
, nvarchar @originator_publication)
MetaData:
create procedure sys.sp_MSpeersendresponse ( @request_id int, @originator sysname, @originator_db sysname, @originator_publication sysname ) as begin set nocount on declare @retcode int, @cmd nvarchar(4000), @response_srvr sysname, @response_db sysname -- security check for subscriber -- Though the work below is related to a publisher, we use -- a check for the subscriber because this is normally executed -- by the distribution agent at a subscriber (republisher). -- this should only be used by peer to peer subscribers. exec @retcode = sys.sp_MSreplcheck_subscribe if @@error <> 0 or @retcode <> 0 begin return 1 end select @cmd = NULL, @response_srvr = publishingservername(), @response_db = db_name() -- if are on the originator then no-op if UPPER(@originator) = UPPER(@response_srvr) and @originator_db = @response_db begin return 0 end begin transaction tr_sp_MSpeersendresponse save transaction tr_sp_MSpeersendresponse select @cmd = N'exec sys.sp_MSpeerapplyresponse @request_id=' + cast(@request_id as nvarchar) + N',@originator=N' + quotename(@originator, '''') + N',@originator_db=N' + quotename(@originator_db, '''') + N',@response_srvr=N' + quotename(@response_srvr, '''') + N',@response_db=N' + quotename(@response_db, '''') exec @retcode = sys.sp_MSpeertopeerfwdingexec @command = @cmd, @publication = @originator_publication if @@error <> 0 or @retcode <> 0 goto FAILURE commit transaction tr_sp_MSpeersendresponse return 0 FAILURE: rollback transaction tr_sp_MSpeersendresponse commit transaction return 1 end
No comments:
Post a Comment