Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.sp_get_mergepublishedarticleproperties

  No additional text.


Syntax
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)

 
Last revision 2008RTM
See also

  sp_MSdrop_rladmin (Procedure)
       



News

  Query a named instance
Sybase+ASE+silent+install
SQL 2008 R2
Deprecated procedures in SQL2008
Reporting Services item-level role definitions
Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash