May 15, 2012

sp_MSgetlastsentgen (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_MSgetlastsentgen(uniqueidentifier @repid)

MetaData:

   
create procedure sys.sp_MSgetlastsentgen
(@repid uniqueidentifier)
as
declare @retcode int

--
-- do permission checking
--
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @repid = @repid
if @retcode<>0 or @@ERROR<>0 return (1)

if object_id('MSmerge_contents') is NULL
begin
RAISERROR(20054 , 16, -1)
return (1)
end

if (@repid is null)
begin
RAISERROR(14043, 16, -1, '@repid', 'sp_MSgetlastsentgen')
return (1)
end

select sentgen, sentguid from dbo.sysmergesubscriptions where subid = @repid
return (0)

No comments:

Post a Comment

Total Pageviews