We have SQLServer 2014,transactional  replication on Azure ARM VM. This started failing with the error Transactional Replication to Pull from the Publisher. I did not choose to update schema or do a Snapshot. And now on the Subscriber I get a message “Could not find stored procedure ‘sp_MSins_<TableName>.’ These procedure get created for each tables/articles that get added to the replication.

 

Categories: Uncategorised

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

Uncategorised

Replication using Remote distributor on ALWAYS ON AVAILABILITY GROUP

In SQL Server, Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. It is highly recommended to Read more…

Uncategorised

Configuring transnational replication on Always on availability group SQL Server 2014

SQL Server replication supports the automatic failover of the publisher, the automatic failover of transactional subscribers, and the manual failover of merge subscribers. The failover of a distributor on an availability database is not supported. In Read more…

Uncategorised

TEMPDB drive full on PRODUCTION

How to shrink tempdb on active production: How am I going to shrink tempdb and release space to OS to suppress the disk space alerts on production without restarting SQL Service. As best practice tempdb Read more…

000webhost logo