Replication

Dear Professional,

I am encountering one error while the data is going to be replicated.

Here is the detail !

Last Command :
{CALL sp_MSins_Master (16, 'Okie', 1,
{5575376A-73CB-419C-9175-F6662FB115B7})}
Transaction sequence number and command ID of last execution batch are
0x0000000B00000197000400000000 and 1.

Error message :
Could not find stored procedure 'sp_MSins_Master'.

Error Detail:
Could not find stored procedure 'sp_MSins_Master'.
(Source: NOOR\NOOR (Data source); Error number: 2812)
-------------------------------------------------------------------

What I have to do for resolving the stored procedure 'sp_MSins_Master'.


Thanks in advance.

The procedure 'sp_MSins_Master' needs to exist in the subscribing database,
for replication to apply the insert statements. If this proc is lost for
some reason, then you can recreate it by runnning
sp_scriptpublicationcustomprocs on the publishing database, copying and
running the output script on the subscribing database.

Note that you only need to run the script for missing stored procedures. See
BOL for more info.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"John" wrote in message

Dear Professional,

I am encountering one error while the data is going to be replicated.

Here is the detail !

Last Command :
{CALL sp_MSins_Master (16, 'Okie', 1,
{5575376A-73CB-419C-9175-F6662FB115B7})}
Transaction sequence number and command ID of last execution batch are
0x0000000B00000197000400000000 and 1.

Error message :
Could not find stored procedure 'sp_MSins_Master'.

Error Detail:
Could not find stored procedure 'sp_MSins_Master'.
(Source: NOOR\NOOR (Data source); Error number: 2812)
-------------------------------------------------------------------

What I have to do for resolving the stored procedure 'sp_MSins_Master'.


Thanks in advance.