May 16, 2012

sp_MShaschangeslightweight (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_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

Total Pageviews