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

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…

Uncategorised

Adding new tables to existing Replication

Sometime due to the business requirement you might need to add tables to an existing transactional replication. This might be expensive activity if you add new tables specifically to an existing replication which is having Read more…

Uncategorised

SQL SERVER – The Patch Installer has Failed to Update the Shared Features

Applying a patch in SQL Server is a planned process which is followed across various companies. Most of the companies take time to apply the patch to make sure the stability of the patch can Read more…

www.000webhost.com