Wednesday, July 19, 2017

Snapshot Replication - Blocking Issue

Please run below command on publisher to avoid blocking while generating snapshot for replication.

/*------------------------
EXEC sp_changepublication
@publication = N'Pub_Name,
@property = N'sync_method',
@value = 'database snapshot'
GO

------------------------*/