Поделиться через

  • Статья

Свойство SnapshotJobId

Gets the Snapshot Agent job ID for the current publication.

Пространство имен:  Microsoft.SqlServer.Replication
Сборка:  Microsoft.SqlServer.Rmo (в Microsoft.SqlServer.Rmo.dll)

Синтаксис

'Декларация
Public ReadOnly Property SnapshotJobId As String
    Get
'Применение
Dim instance As Publication
Dim value As String

value = instance.SnapshotJobId

public string SnapshotJobId { get; }

public:
property String^ SnapshotJobId {
    String^ get ();
}

member SnapshotJobId : string

function get SnapshotJobId () : String

Значение свойства

Тип: System. . :: . .String
A String value that represents a unique identifier.

Замечания

The SnapshotJobId property can only be retrieved by members of the sysadmin fixed server role at the Publisher, by members of the db_owner fixed database role on the publication database, or by users in the publication access list (PAL).

Retrieving the SnapshotJobId property is equivalent to executing sp_helppublication (Transact-SQL) or sp_helpmergepublication (Transact-SQL).

The SnapshotJobId property is available with SQL Server 7.0, SQL Server 2000, and SQL Server 2005.