June 4, 2012

sp_MSsubscriptionvalidated (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_MSsubscriptionvalidated(uniqueidentifier @subid
, uniqueidentifier @pubid
, bit @log_attempt)

MetaData:

   
create procedure sys.sp_MSsubscriptionvalidated
@subid uniqueidentifier,
@pubid uniqueidentifier,
@log_attempt bit = 0
as
declare @now datetime
declare @retcode int

select @now=getdate()

if ({fn ISPALUSER(@pubid)} <> 1)
begin
if (@pubid is NULL)
begin
RAISERROR (21723, 16, -1, 'sp_MSsubscriptionvalidated')
return 1
end
else
begin
RAISERROR (14126, 11, -1)
return 1
end
end

if @log_attempt=0
update dbo.sysmergesubscriptions set last_validated = @now, attempted_validate=@now
where subid = @subid and pubid = @pubid
else
update dbo.sysmergesubscriptions set attempted_validate = @now
where subid = @subid and pubid = @pubid
if @@rowcount <> 1 or @@error <> 0
begin
RAISERROR (20070, 16, -1)
return (1)
end
return (0)

No comments:

Post a Comment

Total Pageviews