Skip to main content
1 of 3

MS SQL Server 2005 to 2012 Replication, can not acces replicated data

I have created publication (snapshot, small table with 10 rows) on MS SQL Server 2005. Then 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 tabe is locked. Replication monitor shows everything ok. Distribution service is running on MS SQL Server 2005. I see replication files created on network share.
Why I can not access table ?