Finally I figure out what to do !. "Allow Pull Subcriptions" should be unchecked in Subcription options tab screen of publication properties. Note:...
I am using Transactional replication. In Publication Properties - Snapshot folder, I have checked "Do not not lock tables during snapshot generation....
I do have same problem. I have click the check box "Do not lock tables during snapshot generation", still the sql server locks the whole database...
Separate names with a comma.
