sp_resetsnapshotdeliveryprogress (Transact-SQL)
SQL Server 2005
Resets the snapshot delivery process for a pull subscription so that snapshot delivery can be restarted. Executed at the Subscriber on the subscription database.
Transact-SQL Syntax Conventions
- [ @verbose_level= ] verbose_level
-
Specifies the amount of information returned. verbose_level is int, with a default of 1. A value of 1 means that an error is returned if the necessary locks cannot be obtained on the MSsnapshotdeliveryprogress table, and 0 means that no error is returned.
- [ @drop_table= ] 'drop_table'
-
Is whether to drop or truncate the table containing information on the progress of the snapshot. drop_table is nvarchar(5), with a default of FALSE. false means that the table is truncated, and true means the table is dropped.
