Hi NG,
after setting up a transactional replication we get the
following error from the distribution agent
"Could not find stored procedure 'sp_MSins_alarm_log'.
(Source: ESLTSRV2 (Data source); Error number: 2812)"
Both servers are running SQL 2000 with SP 3 under Windows
2003. The Servers are manually synchronized and we have
another transactional replication which works fine.
How can we fix this error and what has going wrong.

Thx in advance
Hans

Hello Hans,

With transactional replication, there are insert, update and delete stored
procedures created for each table in the publication. These stored
procedures are created automatically when the subscription is auto-synched.
When you manually synch a subscription, these stored procedures are not
created. You have to use the stored procedure
sp_scriptpublicationcustomprocs to create them on the subscriber. Books
OnLine has more information about this stored procedure and how to use it.

Regards,
Shirley
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.