Export (0) Print
Expand All

TransPublication.SnapshotAvailable Property

Gets whether or not the snapshot files for this publication are available for use.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public bool SnapshotAvailable { get; }

Property Value

Type: Boolean
A Boolean value. If true, the snapshot files are available. If false, the snapshot files are not available.

The SnapshotAvailable 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 SnapshotAvailable property is equivalent to executing sp_helppublication.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft