Thursday, March 8, 2012

Could not find stored procedure 'sp_MSins_<table_name>'.

Error message for a Distribution Agent:
"Could not find stored procedure 'sp_MSins_<table_name>'."
Elham,
looks like you have set up things manually. You can still create the stored
procedure scripts and apply them at the subscriber, or alternatively allow
the snapshot to create everything (inc data files) and reinitialize. To
manually create the scripts, use sp_scriptpublicationcustomprocs. There are
details in this article:
http://support.microsoft.com/default...;EN-US;299903.
HTH,
Paul Ibison

No comments:

Post a Comment