June 11, 2012

sp_stoppullsubscription_agent (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_stoppullsubscription_agent(nvarchar @publisher
, nvarchar @publisher_db
, nvarchar @publication)

MetaData:

 create procedure sys.sp_stoppullsubscription_agent  
(
@publisher sysname,
@publisher_db sysname,
@publication sysname
)
as
begin
set nocount on
declare @retcode int
,@stop tinyint

set @retcode = 0
set @stop = 1

-- Security check
exec @retcode = sys.sp_MSreplcheck_subscribe
if @@error <> 0 or @retcode <> 0
return 1

exec @retcode = sys.sp_MSpullsubscriptionagentjobcontrol
@publisher = @publisher,
@publisher_db = @publisher_db,
@publication = @publication,
@action = @stop
return @retcode
end

No comments:

Post a Comment

Total Pageviews