Specifies the amount of information returned. verbose_levelis 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.
sp_resetsnapshotdeliveryprogress removes all rows in the MSsnapshotdeliveryprogress table. This effectively removes all metadata left behind at the subscription database by any previous progress made in the snapshot delivery processes.