Skip to main content
2 of 3
added 41 characters in body; edited tags; edited title
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

SQL Server 2005 to 2012 Replication, cannot access replicated data

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.

##My Observations

  • 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 ?