Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Namespace:

Microsoft.SqlServer.Replication

Assembly:

Microsoft.SqlServer.Rmo.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

public:
 void CommitPropertyChanges();

public void CommitPropertyChanges();

member this.CommitPropertyChanges : unit -> unit

Public Sub CommitPropertyChanges ()

Examples

// Define the server, database, and publication names
string publisherName = publisherInstance;
string publicationName = "AdvWorksProductTran";
string publicationDbName = "AdventureWorks2012";

TransPublication publication;

// Create a connection to the Publisher.
ServerConnection conn = new ServerConnection(publisherName);

try
{
 // Connect to the Publisher.
 conn.Connect();

 // Set the required properties for the publication.
 publication = new TransPublication();
 publication.ConnectionContext = conn;
 publication.Name = publicationName;
 publication.DatabaseName = publicationDbName;

 // Explicitly enable caching of property changes on this object.
 publication.CachePropertyChanges = true;

 // If we can't get the properties for this publication, 
 // throw an application exception.
 if (publication.LoadProperties())
 {
 // Enable support for push subscriptions and disable support 
 // for pull subscriptions.
 if ((publication.Attributes & PublicationAttributes.AllowPull) != 0)
 {
 publication.Attributes ^= PublicationAttributes.AllowPull;
 }
 if ((publication.Attributes & PublicationAttributes.AllowPush) == 0)
 {
 publication.Attributes |= PublicationAttributes.AllowPush;
 }

 // Send changes to the server.
 publication.CommitPropertyChanges();
 }
 else
 {
 throw new ApplicationException(String.Format(
 "Settings could not be retrieved for the publication. " +
 "Ensure that the publication {0} exists on {1}.",
 publicationName, publisherName));
 }
}
catch (Exception ex)
{
 // Do error handling here.
 throw new ApplicationException(
 "The publication property could not be changed.", ex);
}
finally
{
 conn.Disconnect();
}

' Define the server, database, and publication names
Dim publisherName As String = publisherInstance
Dim publicationName As String = "AdvWorksProductTran"
Dim publicationDbName As String = "AdventureWorks2012"

Dim publication As TransPublication

' Create a connection to the Publisher.
Dim conn As ServerConnection = New ServerConnection(publisherName)

Try
 ' Connect to the Publisher.
 conn.Connect()

 ' Set the required properties for the publication.
 publication = New TransPublication()
 publication.ConnectionContext = conn
 publication.Name = publicationName
 publication.DatabaseName = publicationDbName

 ' Explicitly enable caching of property changes on this object.
 publication.CachePropertyChanges = True

 ' If we can't get the properties for this publication, 
 ' throw an application exception.
 If publication.LoadProperties() Then
 ' Enable support for push subscriptions and disable support 
 ' for pull subscriptions.
 If (publication.Attributes And PublicationAttributes.AllowPull) <> 0 Then
 publication.Attributes = publication.Attributes _
 Xor PublicationAttributes.AllowPull
 End If
 If (publication.Attributes And PublicationAttributes.AllowPush) = 0 Then
 publication.Attributes = publication.Attributes _
 Or PublicationAttributes.AllowPush
 End If

 ' Send changes to the server.
 publication.CommitPropertyChanges()
 Else
 Throw New ApplicationException(String.Format( _
 "Settings could not be retrieved for the publication. " + _
 "Ensure that the publication {0} exists on {1}.", _
 publicationName, publisherName))
 End If
Catch ex As Exception
 ' Do error handling here.
 Throw New ApplicationException( _
 "The publication property could not be changed.", ex)
Finally
 conn.Disconnect()
End Try

Remarks

The statements are stored or executed depending on the SqlExecutionModes property of the ServerConnection object.