次の方法で共有

  • [アーティクル]

DestinationObjectName Property

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。 新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。

The DestinationObjectName property specifies the name of table or stored procedure created as the target of a transactional replication article.

構文

object.DestinationObjectName [=value]

Parts

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

  • value
    A string that specifies a valid Microsoft SQL Server table or stored procedure name

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDestinationObjectName(SQLDMO_LPBSTR pRetVal);
HRESULT SetDestinationObjectName(SQLDMO_LPCSTR NewValue);
注意注意

SQL Distributed Management Objects (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 using SysFreeString.

説明

For a TransArticle object, the SourceObjectName property provides the default for DestinationObjectName.

Specify an alternate owner for the published object using the DestinationOwnerName property.

Although the DestinationObjectName property is a read/write property of the TransArticle object, setting DestinationObjectName for a MergeArticle2 object has no effect. The value of the DestinationObjectName property of the MergeArticle2 object is always the same as the value of the SourceObjectName property.

注意注意

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