My merge replication scheme has suddenly started failing. When trying to sync it complains that there is an invalid object. 'dbo.myfunction'. The function used to exist but was removed. There was only one reference to it from a table valued function and it has been updated as well. I've generated a new snapshot but it continues to complain that the object is invalid and will not sync at the subscriber.

Somewhere within the replication it's still looking for that function. How do I find and remove it - when it's not there anymore.

I've even looked through the files in the snapshot and cannot find anywhere that it is being referenced.

My publisher is SQL 2008 R2 - all my subscribers are SQL 2008 Express