April 27, 2012

sp_helppeerresponses (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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_helppeerresponses(int @request_id)

MetaData:

 create procedure sys.sp_helppeerresponses  
(
@request_id int
)
as
begin
declare @retcode int

-- Security Check
exec @retcode = sys.sp_MSreplcheck_publish
if @@error <> 0 or @retcode <> 0
begin
return 1
end

-- Check to see if database is activated for publication
if sys.fn_MSrepl_istranpublished(db_name(),0) <> 1
begin
RAISERROR (14013, 16, -1)
return 1
end

-- return results
select *
from MSpeer_response
where request_id = @request_id

return 0
end

No comments:

Post a Comment

Total Pageviews