Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Displays or changes publisher properties for non-Microsoft SQL Server Publishers. This stored procedure is executed at the Distributor.
Is the name of the heterogeneous Publisher. publisher is sysname, with no default.
[@propertyname = ] 'propertyname'
Is the name of the property being set. propertyname is sysname, and can be one of the following values.
If transactions at the Publisher are grouped into transactionally consistent sets for subsequent processing, known as Xactsets. A value of enabled means that Xactsets can be created, which is the default. A value of disabled means that existing Xactsets are processed by no new Xactsets are created.
If the Xactset job is enabled for the creation of Xactsets. A value of enabled means that the Xactset job runs periodically to create Xactsets at the publisher. A value of disabled means that the Xactsets are only created by the Log Reader Agent when it polls the Publisher for changes.
Interval between executions of the Xactset job, in minutes.
When propertyname is omitted all settable properties are returned.
[@propertyvalue = ] 'propertyvalue'
Is the new value for the property setting. propertyvalue is sysname, with a default value of NULL. When propertyvalue is omitted, the current setting for the property is returned.