Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_browsemergesnapshotfolder
Collapse the table of content
Expand the table of content

sp_browsemergesnapshotfolder

SQL Server 2000

  New Information - SQL Server 2000 SP3.

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

Syntax

sp_browsesnapshotfolder [@publication = ] 'publication'

Arguments

[@publication =] 'publication'

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

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

Remarks

sp_browsemergesnapshotfolder is used in merge replication.

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_browsemergesnapshotfolder is useful for determining the directory where the merge snapshot files are generated.  This folder/path and its contents can then be copied to removable media, and the snapshot used to synchronize a subscription from an alternate snapshot location.

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

Show:
© 2015 Microsoft