How to Browse and Copy Snapshot Files (Transact-SQL)

How to Install SQL Server 2000

How To

How to Browse and Copy Snapshot Files (Transact-SQL)

To browse snapshot files

  • For transactional publications, execute the sp_browsesnapshotfolder Transact-SQL system stored procedure at the Publisher.

  • For merge publications, execute the sp_browsemergesnapshotfolder Transact-SQL system stored procedure at the Publisher.

To copy snapshot files

  • For transactional publications, execute the sp_copysnapshot Transact-SQL system stored procedure at the Publisher.

  • For merge publications, execute the sp_copymergesnapshot Transact-SQL system stored procedure at the Publisher.