May 11, 2012

sp_MSenumarticleslightweight (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_MSenumarticleslightweight(uniqueidentifier @pubid)

MetaData:

 create procedure sys.sp_MSenumarticleslightweight  
@pubid uniqueidentifier
as
declare @retcode int

exec @retcode= sys.sp_MSreplcheck_publish
if @@error <> 0 or @retcode <> 0 return (1)

select
a.name, a.destination_object, a.artid, a.pubid, a.nickname,
a.column_tracking, a.destination_owner, a.identity_support, a.well_partitioned_lightweight,
a.processing_order, a.upload_options, i.range, i.threshold, a.delete_tracking, a.compensate_for_errors,
a.stream_blob_columns
from dbo.sysmergearticles a left outer join dbo.MSmerge_idrange i on a.objid = i.objid
where a.pubid=@pubid and
a.lightweight=1

No comments:

Post a Comment

Total Pageviews