I have created publication (snapshot, small table with 10 rows) on MS SQL Server 2005. Then, I created push subscription on MS SQL Server 2012. When I try to select data form table, process takes several minutes after that I got error. It looks like table is locked.
- Replication monitor shows everything is OK.
- Distribution service is running on MS SQL Server 2005.
- I see replication files created on network share.
Why can I not access the table ?