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

sp_browsesnapshotfolder

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Returns the complete path for the latest snapshot generated for a publication. This stored procedure is executed at the Publisher on the publication database.

Syntax

sp_browsesnapshotfolder [@publication = ] 'publication'
    { [ , [ @subscriber = ] 'subscriber' ]
     [ , [ @subscriber_db = ] 'subscriber_db' ] }

Arguments

[@publication =] 'publication'

Is the name of the publication that contains the article. publication is sysname, with no default.

[@subscriber =] 'subscriber'

Is the name of the Subscriber. subscriber is sysname, with a default of NULL.

[@subscriber_db=] 'subscriber_db'

Is the name of the subscription database. subscriber_db is sysname, with a default of NULL.

Result Sets
Column name Data type Description
snapshot_folder nvarchar(512) Full path to the snapshot directory.

Remarks

sp_browsesnapshotfolder is used in snapshot replication and transactional replication.

If the subscriber and subscriber_db fields are left NULL, the stored procedure will return the snapshot folder of the most recent snapshot it can find for the publication. If the subscriber and subscriber_db fields are specified, the stored procedure will return the snapshot folder for the specified subscription. If a snapshot has not been generated for the publication, an empty result set will be returned.

If the publication is set up to generate snapshot files in both the Publisher working directory and Publisher snapshot folder, the result set will contain two rows:; . the first row  will contain  the publication snapshot folder and the second row will contain the publisher working directory.sp_browsesnapshotfolder is useful for determining the directory where snapshot files are generated.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_browsesnapshotfolder.

See Also

Exploring Snapshots

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.