could not find stored procedure 'dbo.sp_MSdropfkreferencingarticle'

Hi, I'm trying to generate a snapshot of a database (running on SQL 2005 SP1) prior to starting transactional replication to an SQL 7.0 server. After generating the snapshot, the agent fails with the error message 'could not find stored procedure 'dbo.sp_MSdropfkreferencingarticle' and suggests lookin at error number 2812 (which offers no help).

I was convinced this worked prior to installing SP1, but that testing was done some time ago....

Andy, this is a bug we need to fix (I am guessing you are using "truncate" as the pre-creation command). To workaround for now, you can:

1) Use drop as the pre-creation command

2) Create a dummy procedure "sp_MSdropfkreferencingarticle" at your 70 subscriber

-Raymond

|||Thanks Raymond, creating the dummy stored procedure worked OK without changing the pre-creation command from truncate to drop.