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_get_mergepublishedarticleproperties(nvarchar @source_object, nvarchar @source_owner)
MetaData:
create procedure sys.sp_get_mergepublishedarticleproperties ( @source_object sysname = NULL, -- The name of the object -- @source_owner sysname = NULL -- The name of the owner of the object -- ) AS SET NOCOUNT ON declare @retcode int -- -- Check for dbo permission -- exec @retcode=sys.sp_MSreplcheck_subscribe if @retcode<>0 or @@ERROR<>0 return (1) -- -- Declarations. -- declare @objid int declare @partition_options tinyint IF object_id('sysmergearticles') is NULL RETURN (0) if @source_object IS NULL BEGIN RAISERROR (14043, 16, -1, '@source_object', 'sp_get_mergepublishedarticleproperties') RETURN (1) END if @source_owner IS NULL select @objid = object_id(quotename(@source_object)) else select @objid = object_id(quotename(@source_owner) + '.' + quotename(@source_object)) if @objid is NULL RETURN(0) if object_id('sysmergepartitioninfo') is not NULL begin select top 1 @partition_options = smpi.partition_options from dbo.sysmergepartitioninfo as smpi join sysmergearticles as sma on sma.artid = smpi.artid and sma.pubid = smpi.pubid where @objid = sma.objid order by sma.pubid end select top 1 column_tracking as column_tracking, schema_option as schema_option, vertical_partition as vertical_partition, identity_support as identity_support, upload_options as subscriber_upload_options, well_partitioned_lightweight as well_partitioned_lightweight, delete_tracking as delete_tracking, compensate_for_errors as compensate_for_errors, pub_range as pub_range, range as range, threshold as threshold, @partition_options as partition_options, stream_blob_columns as stream_blob_columns from dbo.sysmergearticles where @objid = objid order by pubid RETURN (0)
No comments:
Post a Comment