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_MShaschangeslightweight(uniqueidentifier @pubid)MetaData:
create procedure sys.sp_MShaschangeslightweight @pubid uniqueidentifier, @haschanges int output as set nocount on declare @retcode smallint set @haschanges= 0 exec @retcode= sys.sp_MSreplcheck_subscribe if @@error <> 0 or @retcode <> 0 return (1) -- find out whether at least one article that belongs to the publication has changes if exists (select top 1 * from dbo.MSmerge_rowtrack where tablenick in (select nickname from dbo.sysmergearticles where pubid = @pubid) ) begin set @haschanges= 1 end if @@error <> 0 return 1 return 0
No comments:
Post a Comment