TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_browsemergesnapshotfolder (Transact-SQL)

 

Applies To: SQL Server

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.

Topic link icon Transact-SQL Syntax Conventions

  
sp_browsemergesnapshotfolder [@publication= ] 'publication'  

[ @publication=] 'publication'
Is the name of the publication. publication is sysname, with no default.

0 (success) or 1 (failure)

Column nameData typeDescription
snapshot_foldernvarchar(2000)Full path to the snapshot directory.

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 contains two rows: the first row contains the publication snapshot folder, and the second row contains 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.

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

System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft