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