Getting Started with Web applications development with servlets and JSP - Part 5: Filters
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


Upload Image Close it
Select File

Learned something today? Share it, or learn from what others have learned today

SQL Server Replication- "Could not find stored procedure 'sp_MSins_TableName' in replication in sql server" - Log reader agent e

Nov 1 2011 4:38AM by Paresh Prajapati   

I encountered an error mentioned in title from log reader agent after reinitialize all subscription for one publication and it stopped working. This is due to replication object was not created for insert and named like 'spMSinsTableName'.

The solution for this issue, we need to create these missing replication objects using 'sp_scriptpublicationcustomprocs' which generates scripts the custom INSERT, UPDATE, and DELETE procedures for all table articles in a publication.

<pre class="brush: plain">
EXEC sp_scriptpublicationcustomprocs 'PublicationName' 
</pre>

after running generated scripts in subscriber database, log reader agent started to work.

Read More..  [7 clicks]


Paresh Prajapati
7 · 24% · 5511
5
 
0
Knew
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten
 
0
Move



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server Replication- "Could not find stored procedure 'sp_MSins_TableName' in replication in sql server" - Log reader agent e" rated 5 out of 5 by 5 readers
SQL Server Replication- "Could not find stored procedure 'sp_MSins_TableName' in replication in sql server" - Log reader agent e , 5.0 out of 5 based on 5 ratings
    Copyright © Beyondrelational.com Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising