SnapshotObjectName Property (SQL-DMO)

The SnapshotObjectName identifies the Microsoft® SQL Server™ database object providing an initial snapshot of replicated data for an article.

Applies To

MergeArticle Object

TransArticle Object

Syntax

object.SnapshotObjectName [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	String identifying a SQL Server table or view by name

Remarks

By default, the database object providing the initial snapshot is the object providing replicated data. Override the initial snapshot source object to control the data populating the snapshot.

To override the initial snapshot

Set the ArticleType property to indicate manual creation of the initial snapshot. ArticleType must be SQLDMORep_LogBasedManualBoth, SQLDMORep_LogBasedManualSyncView, or SQLDMORep_ManualSyncView.
Set the SnapshotObjectName and SnapshotObjectOwner properties to identify the snapshot data source object.
To generate a synchronizing snapshot, execute the ReInitializeAllSubscriptions method of the TransPublication object containing the referenced transactional replication article.

Data Type

String

Modifiable

Read/write for a TransArticle object. Read-only for a MergeArticle object.

Prototype (C/C++)

HRESULT GetSnapshotObjectName(SQLDMO_LPBSTR pRetVal);

HRESULT SetSnapshotObjectName(SQLDMO_LPCSTR NewValue);

Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.