Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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: System.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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.