May 8, 2012

sp_MScheckexistsgeneration (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_MScheckexistsgeneration(uniqueidentifier @genguid
, uniqueidentifier @pubid)

MetaData:

   
CREATE PROCEDURE sys.sp_MScheckexistsgeneration
(@genguid uniqueidentifier, @gen bigint output, @pubid uniqueidentifier = NULL)
as
declare @retcode int
--
-- Check input parameter
--
if (@genguid is null)
begin
RAISERROR(14043, 16, -1, '@genguid', 'sp_MScheckexistsgeneration')
return (1)
end

-- security check
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @pubid = @pubid
if (@retcode <> 0) or (@@error <> 0)
return 1

-- Normal case : do not qualify by pubid --
if (@pubid IS NULL)
select @gen = max(generation) from dbo.MSmerge_genhistory where guidsrc = @genguid and genstatus in (1,2)
else
-- If we are reinitializing from an alternate publisher, check if the subscription has received generations for the alternate publication --
select @gen = max(generation) from dbo.MSmerge_genhistory where guidsrc = @genguid and genstatus in (1,2)
and ((pubid = @pubid) or (pubid is null))
IF @@ERROR <>0 return (1)
-- OLEDB does not allow output parameter to be NULL - setting it to 0 --
return (0)

No comments:

Post a Comment

Total Pageviews