May 8, 2012

sp_MScomputelastsentgen (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


sys.sp_MScomputelastsentgen(uniqueidentifier @repid)


 create procedure sys.sp_MScomputelastsentgen  
(@repid uniqueidentifier)
declare @retcode int
declare @mingen bigint
declare @lastsentgen bigint
declare @lastsentguid uniqueidentifier

-- this proc should be called on the subscriber. Hence dbo check is good
exec @retcode = sys.sp_MSreplcheck_subscribe
if @@error <> 0 or @retcode <> 0
return 1

select @lastsentgen = max(g.generation)
from MSmerge_genhistory g,
(select isnull(gen2.generation, gen1.generation) as generation
from (select max(generation) as generation from dbo.MSmerge_genhistory where genstatus in (1,2)) as gen1,
(select min(generation) as generation from dbo.MSmerge_genhistory where genstatus in (0,4)) as gen2
) as minopengen
where g.generation <= minopengen.generation and g.genstatus in (1,2)

if @lastsentgen is not NULL
select @lastsentguid = guidsrc from dbo.MSmerge_genhistory where generation = @lastsentgen
exec @retcode = sys.sp_MSsetlastsentgen @repid, @lastsentgen, @lastsentguid
if @@error <> 0 or @retcode <> 0
-- should never get here
RAISERROR('Setting sentgen failed.', 16, -1)
return 1

No comments:

Post a Comment

Total Pageviews