Freigeben über


PreCreationMethod Property

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The PreCreationMethod property controls Subscriber replication object changes when article synchronization occurs.

Syntax

object.PreCreationMethod [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.

  • value
    A long integer that specifies a row modifying action at the Subscriber as described in Settings.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetPreCreationMethod(
SQLDMO_PREARTICLE_TYPE* pRetVal);
HRESULT SetPreCreationMethod(
SQLDMO_PREARTICLE_TYPE NewValue);

Settings

Constant

Value

Description

SQLDMOPreArt_DeleteRows

2

Performs a logged delete prior to synchronization.

SQLDMOPreArt_DropTable

1

Drops and then re-creates the table to synchronize.

SQLDMOPreArt_None

0

Does nothing prior to synchronization.

SQLDMOPreArt_TruncateTable

3

Performs a bulk-logged deletion prior to synchronization.

Hinweise

If an application sets PreCreationMethod after the initial snapshot has been created, a new snapshot must be generated and then reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and distribution or merge agent run.