Skip to main content
Database Administrators

Return to Question

Commonmark migration
Source Link
Community Bot
Community Bot
  • 1

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

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 ?

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 ?

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 ?

added 41 characters in body; edited tags; edited title
Source Link
RolandoMySQLDBA
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

MS SQL Server 2005 to 2012 Replication, can not accescannot 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 When I try to select data form table, process takes several minutes after that I got error. It looks like tabetable 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

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

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 ?

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 ?

Source Link
Andvil
Andvil
  • 1
  • 1

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 ?